Microsoft Certified: Azure Solutions Architect ExpertDesign data storage solutionsMedium
A global online gaming company is developing a new massively multiplayer online role-playing game (MMORPG). The game requires a database to store player profiles, inventory, character statistics, and game state. This data needs to be highly available globally, with low-latency reads and writes from any region, and must scale elastically to accommodate millions of concurrent players. The data model is document-oriented and subject to frequent schema changes as new game features are introduced. Which Azure data storage solution is most suitable for these requirements?
- AAzure Cosmos DB (Core SQL API)
- BAzure Table Storage
- CAzure Database for PostgreSQL
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Cosmos DB (Core SQL API)
Azure Cosmos DB (Core SQL API) is a globally distributed, multi-model database service that offers turn-key global distribution, elastic scalability, and guaranteed low-latency access, making it ideal for the described gaming scenario with its document-oriented data model and schema flexibility.
Why the other options are wrong
- B. Azure Table Storage is a key-value store optimized for high-volume unstructured data but offers limited querying capabilities and does not provide the same level of global distribution, consistency guarantees, or advanced features as Cosmos DB.
- C. Azure Database for PostgreSQL is a relational database and provides strong consistency but lacks the native global distribution, elastic scalability, and schema flexibility needed for this scale and type of application.
- D. Azure SQL Database is a relational database and excels at structured data with fixed schemas, which is not ideal for the flexible, document-oriented data model and rapid schema changes required.
Azure Cosmos DB (Core SQL API)
A globally distributed, multi-model database service that offers turn-key global distribution, elastic scalability, and guaranteed low-latency access for various data models, including document (SQL API).
- Globally distributed with multi-region write capabilities.
- Offers guaranteed low-latency and high availability.
- Supports various APIs, including Core (SQL) for document data.
- Provides elastic scalability for throughput and storage.
Memory trick: Cosmos DB: Global scale, flexible schema, fast as light, for your digital universe.