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 global online gaming company needs a data store for player game session logs. Each log record has a SessionID (unique), PlayerID, GameID, StartTime, EndTime, and a JSON payload containing variable game state details. The company requires low-latency writes for millions of concurrent sessions and wants to query by PlayerID and time range. Schema flexibility is important because game state details change frequently. Which Azure data store should they choose?
⚠ Common exam trap
It's easy for candidates to choose Azure Table Storage because they think it is 'NoSQL' and 'fast,' but they overlook its lack of native JSON support and schema flexibility, which are critical for the variable game state payloads described in the question.
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 with the NoSQL API
Azure Cosmos DB with the NoSQL API is the correct choice because it provides low-latency writes (single-digit milliseconds at the 99th percentile) for millions of concurrent sessions, supports schema-flexible JSON documents that can accommodate frequently changing game state payloads, and enables efficient queries by PlayerID and time range using a composite index or a partition key like PlayerID combined with a time-based sort order.
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 with the NoSQL API
Why this is correct
Azure Cosmos DB with the NoSQL API is the optimal choice because it natively stores schema-less JSON documents, allowing player profiles and game telemetry to evolve without migration. It provides turnkey global distribution, single-digit-millisecond latency at any scale, and supports high-throughput point reads/writes with a SQL-like query engine over JSON. This matches the gaming company's need for a flexible, globally available data layer.
- ✗
Azure Table Storage
Why it's wrong here
Azure Table Storage is a simple key-value store that only supports queries by partition key and row key, making it impossible to efficiently filter on arbitrary player attributes like level or region. It lacks built-in global distribution, requiring manual replication or higher latency for cross-region users. While it handles large volumes of structured data, it cannot match Cosmos DB's low-latency, multi-field querying capabilities.
- ✗
Azure Blob Storage
Why it's wrong here
Azure Blob Storage stores binary and text blobs without any schema or query engine, so you cannot retrieve individual player records by field values—you would need to download entire blobs and process them externally. It is engineered for massive scale of unstructured objects, not for low-latency point lookups or transactional updates. Using it here would force you to build and operate a separate indexing layer to make the data queryable.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database imposes a fixed relational schema, requiring every player attribute to be defined as a column and all relationships normalized, which conflicts with the need for flexible JSON payloads that change over time. While it offers JSON functions, they work within a strongly typed table structure, so you lose the document flexibility. Its scalability for highly concurrent global workloads also typically shards at the application layer, adding complexity compared to Cosmos DB's automatic partitioning.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
Key term
Index
An index is a data structure that speeds up data retrieval operations on a database table or file, much like a book index helps you find topics quickly.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.