Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureHard

A global gaming company needs to store player profiles, game statistics, and leaderboards. Player profiles are frequently updated, game statistics are written frequently but read less often, and leaderboards require very low latency reads and writes for real-time updates. The data model is mostly document-oriented with some nested structures. Which Azure non-relational data service provides the necessary flexibility, performance, and global distribution for all these requirements?

  1. AAzure Blob Storage
  2. BAzure Cosmos DB
  3. CAzure Data Lake Storage Gen2
  4. DAzure Table Storage
Show answer & explanation

Correct answer: B. Azure Cosmos DB

Azure Cosmos DB is a globally distributed, multi-model database service that provides turn-key global distribution, guaranteed low latency, and flexible schema support (document-oriented). It can handle all the described workloads effectively.

Why the other options are wrong

  • A. Azure Blob Storage is object storage, not a database service for structured or semi-structured data requiring querying.
  • C. Azure Data Lake Storage Gen2 is optimized for big data analytics, not for transactional, low-latency database workloads.
  • D. Azure Table Storage is a simple key-value store, lacking the flexibility and performance for these diverse needs.

Azure Cosmos DB Core Capabilities

Azure Cosmos DB is Microsoft's globally distributed, multi-model database service for mission-critical applications, offering guaranteed low latency, high availability, and elastic scalability.

  • Globally distributed with multi-region write capabilities.
  • Guaranteed low latency (single-digit milliseconds).
  • Supports multiple APIs (NoSQL, MongoDB, Cassandra, Gremlin, Table).
  • Elastic scalability for throughput and storage.

Memory trick: Cosmos is the one true star for global, fast, and flexible data.

More Describe how to work with non-relational data on Azure questions