Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureEasy
A global gaming company needs to store player profiles, game statistics, and leaderboards. This data must be highly available, globally distributed, and support multiple data models, including document and key-value. Which Azure non-relational data service is best suited for these requirements?
- AAzure Table Storage
- BAzure Queue Storage
- CAzure Cosmos DB
- DAzure Data Lake Storage Gen2
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that offers high availability, low latency, and supports various APIs like SQL (document), Cassandra, MongoDB, Gremlin, and Table (key-value). This makes it ideal for the described gaming scenario.
Why the other options are wrong
- A. Azure Table Storage is a key-value store, but it lacks global distribution capabilities and the multi-model support of Cosmos DB.
- B. Azure Queue Storage is for storing large numbers of messages in a queue, not for persistent, queryable player data.
- D. Azure Data Lake Storage Gen2 is primarily for big data analytics and data lakes, not for transactional, globally distributed operational data like player profiles.
Azure Cosmos DB
Azure Cosmos DB is Microsoft's globally distributed, multi-model database service for managing data at planet-scale. It provides guaranteed low latency, high availability, and supports multiple APIs.
- Globally distributed, multi-region write capabilities.
- Supports multiple data models (document, key-value, graph, column-family).
- Guaranteed low latency and high availability with SLAs.
- Elastic scalability of throughput and storage.
Memory trick: Cosmos DB: A universe of data, everywhere, for everything.