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

A small startup is developing a new mobile application. They need a database service that can handle unpredictable spikes in traffic, scale automatically to meet demand, and provide low-latency access globally. The application will primarily store user profiles and session data. Which Azure database service is the most appropriate choice?

  1. AAzure Database for PostgreSQL
  2. BAzure SQL Database
  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 designed for high-performance and automatic scalability, making it ideal for applications with unpredictable traffic and global reach. It supports various APIs including NoSQL, which is well-suited for user profile and session data.

Why the other options are wrong

  • A. Azure Database for PostgreSQL is a relational database service, less suited for automatic global scaling and NoSQL data models.
  • B. Azure SQL Database is a relational database service, optimized for SQL workloads but not inherently designed for global distribution and multi-model flexibility like Cosmos DB.
  • C. Azure Database for MySQL is a relational database service, similar to PostgreSQL in its limitations for this specific scenario.

Azure Cosmos DB

A globally distributed, multi-model database service offered by Microsoft Azure. It provides turn-key global distribution, elastic scalability, guaranteed low-latency, and multiple APIs for data access.

  • Globally distributed with multi-region write capabilities.
  • Supports multiple data models (document, graph, key-value, column-family).
  • Offers guaranteed low latency and high availability.
  • Elastic scalability for throughput and storage.

Memory trick: Cosmos is for Global Scale and Many Models.

More Describe Azure architecture and services questions