Microsoft Azure Fundamentals (AZ-900)Describe Azure architecture and servicesHard
A global company requires a database solution that can store diverse types of data (documents, key-value, graph, column-family) and provide low-latency access to data from multiple geographic regions. The solution must also offer automatic scaling and high availability. Which Azure database service fits these requirements?
- AAzure Cosmos DB
- BAzure Table Storage
- CAzure Database for PostgreSQL
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that provides low-latency access, automatic scaling, and high availability. Its multi-model nature allows it to support various data types like documents, key-value, graph, and column-family, making it uniquely suited for the described global, diverse data scenario.
Why the other options are wrong
- B. Azure Table Storage is a key-value store, but it does not offer the global distribution, multi-model support, or advanced features of Cosmos DB.
- C. Azure Database for PostgreSQL is also a relational database and does not offer the global distribution and multi-model capabilities of Cosmos DB.
- D. Azure SQL Database is a relational database and does not natively support multiple data models (document, graph, etc.).
Azure Cosmos DB
A globally distributed, multi-model database service that offers high availability, low latency, and automatic scalability.
- Supports multiple APIs: SQL (Core), MongoDB, Cassandra, Gremlin, Table.
- Guaranteed low latency and high availability worldwide.
- Automatic and instant scalability for throughput and storage.
Memory trick: Cosmos DB is a 'Cosmic' database for everything.