An organization is planning to deploy different database workloads to Microsoft Azure. Match each Azure database service to its corresponding capability description.
- Azure Cosmos DBA multi-model database service designed for non-relational data with global scale and schema-less storage.
- Azure SQL Managed InstanceA fully managed relational database service that supports SQL Server agent and cross-database queries without providing operating system access.
- SQL Server on Azure Virtual MachinesA relational database deployment that provides full administrative control over the operating system and database configuration.
Answer
Azure Cosmos DB matches the multi-model database service for non-relational data. Azure SQL Managed Instance matches the fully managed relational database service supporting SQL Server agent without operating system access. SQL Server on Azure Virtual Machines matches the relational database deployment providing full administrative control over the operating system.
Azure Cosmos DB matches the multi-model database service because it is Azure's flagship globally distributed NoSQL database. Azure SQL Managed Instance matches the fully managed relational database service supporting SQL Server agent without operating system access because it acts as a PaaS database offering high compatibility with SQL Server engine features without OS management. SQL Server on Azure Virtual Machines matches the relational database deployment providing full administrative control over the operating system because it is an IaaS solution that places the entire VM under customer control.
Step-by-Step Solution
Key Concept
Understanding the differences between Azure relational databases (Azure SQL Managed Instance, SQL Server on Azure VMs) and non-relational databases (Azure Cosmos DB), alongside IaaS versus PaaS management models.