Describe considerations for working with non-relational data on Azure →mediumMultiple ChoiceObjective-mapped
DP-900 Practice Question: Describe considerations for working with non-relational data on Azure
A mobile gaming company stores player session data as key-value pairs. Each player has a unique PlayerID, and the application needs to read/write the player's current level and score with very low latency. The data does not require complex queries, and the schema (attributes per player) can vary. The company wants a fully managed, globally distributed NoSQL database. Which Azure data store should they choose?
⚠ Common exam trap
Watch out — candidates often confuse Azure Cache for Redis as a durable database, but it is primarily an in-memory cache that requires additional configuration for persistence and global distribution, whereas Cosmos DB Table API is a fully managed, globally distributed NoSQL database with built-in durability and low latency.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Azure Cosmos DB Table API
Azure Cosmos DB Table API is the correct choice because it provides a fully managed, globally distributed NoSQL database that supports key-value data with schema flexibility. It offers low-latency reads and writes (single-digit milliseconds at the 99th percentile) and automatic global distribution, making it ideal for storing player session data with varying attributes per player.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Azure Cosmos DB Table API
Why this is correct
Azure Cosmos DB Table API is a fully managed, schema-agnostic key-value store that excels at high-throughput, low-latency point lookups. Player session data can be naturally modeled with a partition key (e.g., player ID) and row key (e.g., session timestamp), enabling fast reads and writes at global scale. It also offers automatic indexing, configurable consistency levels, and 99.999% availability SLAs, making it ideal for the simple, high-volume key-value access patterns of mobile gaming telemetry.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a relational database with a fixed schema. While it can be used for key-value data, it is not optimized for simple key-value access and lacks flexible schema support without additional configuration.
- ✗
Azure Blob Storage
Why it's wrong here
Azure Blob Storage is an object store designed for unstructured files such as images, videos, logs, and backups, not for row-level key-value operations. While blobs are identified by a URL-style key, they are treated as whole, immutable objects—updating a single player attribute would require rewriting the entire blob, which is inefficient and impractical for frequent session updates. Additionally, there is no built-in query interface for filtering or reading individual fields within a blob, and latencies for small repeated accesses are generally higher than with a purpose-built key-value database like Cosmos DB Table API.
- ✗
Azure Cache for Redis
Why it's wrong here
Azure Cache for Redis is an in-memory cache that offers very low latency, but it is not a durable, fully managed database for persistent storage. Data can be lost if not persisted, and global distribution is not native.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Schema
A schema is a blueprint or logical structure that defines how data is organized, stored, and accessed in a database or information system.
Key term
Table
A table is a structured collection of data organized into rows and columns, used in databases and spreadsheets to store and manage information efficiently.
About these practice questions
Courseiva writes every DP-900 question from scratch — 820 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.