Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureHard
A global online gaming company collects massive amounts of player activity data, including in-game events, chat logs, and purchase history. This data is highly variable, schema-less, and needs to be stored in a globally distributed manner with low-latency access for personalized player experiences and real-time leaderboards. Which Azure database service is most suitable for this scenario?
- AAzure Database for PostgreSQL
- BAzure Synapse Analytics dedicated SQL pool
- CAzure Cosmos DB
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model NoSQL database service that provides low-latency access, high availability, and schema flexibility, making it ideal for variable, high-volume data like gaming activity across global regions.
Why the other options are wrong
- A. Azure Database for PostgreSQL is also a relational database, unsuitable for schema-less, globally distributed, low-latency requirements.
- B. Azure Synapse Analytics dedicated SQL pool is a data warehouse for analytical workloads, not an operational database for real-time, transactional data with schema flexibility.
- D. Azure SQL Database is a relational database with a fixed schema, not ideal for highly variable, schema-less data or global distribution with low latency.
Azure Cosmos DB
Microsoft's globally distributed, multi-model database service for mission-critical applications, offering guaranteed low latency and high availability.
- Supports various NoSQL APIs (SQL, MongoDB, Cassandra, Gremlin, Table).
- Provides global distribution and multi-region writes.
- Guaranteed low latency and high throughput.
Memory trick: Cosmos is vast, fast, and flexible.