Microsoft Azure Fundamentals (AZ-900)Describe Azure architecture and servicesHard

A global software company needs to deploy an application that requires low-latency data access for users worldwide. The application's database must be globally distributed, support multiple data models (key-value, document, graph, column-family), and offer guaranteed throughput and single-digit millisecond latency at the 99th percentile. Which Azure database service should they choose?

  1. AAzure SQL Database
  2. BAzure Database for PostgreSQL
  3. CAzure Database for MySQL
  4. DAzure Cosmos DB
Show answer & explanation

Correct answer: D. Azure Cosmos DB

Azure Cosmos DB is a globally distributed, multi-model database service that offers guaranteed single-digit millisecond latencies at the 99th percentile, elastic scalability of throughput and storage, and multiple well-defined consistency models. This perfectly matches the requirements for global distribution, low-latency, and multi-model support.

Why the other options are wrong

  • A. Azure SQL Database is a relational database and does not support global distribution with guaranteed single-digit millisecond latency or multiple data models natively.
  • B. Azure Database for PostgreSQL is a relational database, unsuitable for multi-model or guaranteed global low-latency requirements.
  • C. Azure Database for MySQL is a relational database and does not provide the global distribution, multi-model support, or latency guarantees required.

Azure Cosmos DB

A globally distributed, multi-model database service that offers elastic scalability, guaranteed low latency, and multiple consistency models for highly responsive applications worldwide.

  • Globally distributed
  • Multi-model (document, graph, key-value, column-family)
  • Guaranteed low latency (single-digit ms)
  • Elastic scalability of throughput and storage

Memory trick: Cosmos DB is the universe of data, everywhere, instantly.

More Describe Azure architecture and services questions