Examkin

Question

Difficulty: HardAzure Database Services (Relational, Non-Relational, and Cosmos DB)

An organization is evaluating its database architecture strategy in Microsoft Azure. Match each specific workload or deployment requirement on the left to the most appropriate Azure database service or hosting model on the right.

  • A fully managed relational database service that automatically handles patching, backups, and high availability, without allowing direct operating system access.Azure SQL Database
  • A globally distributed NoSQL database service that provides single-digit millisecond read and write latencies and support for multiple open-source APIs.Azure Cosmos DB
  • A fully managed relational database service built specifically for applications requiring compatibility with the community edition of the PostgreSQL engine.Azure Database for PostgreSQL
  • An Infrastructure as a Service (IaaS) deployment model that provides full administrative control over the operating system and SQL Server configurations.SQL Server on Azure Virtual Machines

Answer

The correct matches pair the relational, fully managed workload with Azure SQL Database; the low-latency, globally distributed NoSQL workload with Azure Cosmos DB; the open-source community engine compatibility requirement with Azure Database for PostgreSQL; and the workload requiring full OS and database instance administrative control with SQL Server on Azure Virtual Machines.
Matching the database requirements to their respective deployment models requires distinguishing between Platform as a Service (PaaS) databases, Infrastructure as a Service (IaaS) databases, and non-relational versus relational models. Azure SQL Database and Azure Database for PostgreSQL represent fully managed PaaS relational engines. Azure Cosmos DB represents a globally distributed NoSQL PaaS engine. SQL Server on Azure VMs represents an IaaS database deployment where the customer retains full control over the OS and database server configuration.

Step-by-Step Solution

1
Analyze the first requirement: a fully managed relational database with automated patching and no OS access.
This maps to Azure SQL Database, which is a relational PaaS database service.
Azure SQL Database handles all database maintenance automatically while restricting direct OS-level administrative access.
2
Analyze the second requirement: a globally distributed NoSQL database with low latency and multiple APIs.
This maps to Azure Cosmos DB.
Azure Cosmos DB is the primary multi-model NoSQL service in Azure offering global distribution and single-digit millisecond latency.
3
Analyze the third requirement: a fully managed relational database requiring PostgreSQL engine compatibility.
This maps to Azure Database for PostgreSQL.
Azure Database for PostgreSQL provides a fully managed community-compliant version of PostgreSQL.
4
Analyze the fourth requirement: an IaaS model with full administrative control over the OS and database engine.
This maps to SQL Server on Azure Virtual Machines.
Hosting databases on virtual machines represents an IaaS model where the user manages the OS and configurations.

Key Concept

Distinguishing between Azure relational databases (Azure SQL Database, Azure Database for PostgreSQL), non-relational databases (Azure Cosmos DB), and virtual machine hosted databases (SQL Server on Azure VMs).
Estimated Time:2m 0s
Rate this question

Topics

Azure Database Services (Relational, Non-Relational, and Cosmos DB)

More questions from this topic