Globally Distributed JSON Document Database with Schema Evolution
You need to store semi-structured JSON data from a web application. The data schema may change over time. The solution must support low-latency queries and be globally distributed. Which Azure data service should you use?
Quick Answer
This scenario names three requirements, flexible or evolving schema, low latency, and global distribution, and Cosmos DB is built around all three simultaneously rather than requiring trade-offs between them. Because Cosmos DB stores data as JSON documents natively, it does not need a predefined, rigid schema the way a relational table does; when the application's data shape changes over time, new documents can simply include the new fields without any schema migration step, and the database's automatic indexing adapts to the new fields on its own rather than requiring an administrator to update an index definition. Global distribution is handled as a built-in configuration rather than something bolted on afterward; data can be replicated across multiple regions with just a setting, giving users in different geographies fast, local reads. And because indexing happens automatically and continuously as data is written, queries can still return in single-digit milliseconds even as the schema evolves, since there is no separate reindexing process blocking access to newly added fields. This combination of schema flexibility, automatic indexing, and turnkey multi-region replication is Cosmos DB's core value proposition. Whenever a question describes JSON or document-shaped data with a schema that is not fixed, alongside requirements for both low latency and distribution across regions, that combination is the signature of a Cosmos DB scenario rather than a traditional relational database.
⚠ Common exam trap
Test-takers frequently confuse Azure Table Storage's key-value model with document storage, overlooking that it lacks native JSON support and global low-latency query capabilities, while Azure Cosmos DB is specifically designed for these requirements.
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
Azure Cosmos DB is the correct choice because it natively supports semi-structured JSON documents with a flexible schema, offers single-digit-millisecond latency for queries, and provides global distribution with turnkey multi-region replication. Its API for MongoDB or SQL API allows direct ingestion of JSON data, and its schema-agnostic indexing adapts automatically to schema changes over time.
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 Table Storage
Why it's wrong here
Azure Table Storage is a key-value store without native JSON document querying or global multi-region replication of the kind the scenario demands. It is tempting as a cheap schema-flexible store, and would be correct for high-volume key-based lookups within a single region.
- ✓
Azure Cosmos DB
Why this is correct
Azure Cosmos DB stores schema-agnostic JSON natively and indexes every property automatically, so evolving schemas need no migrations. Its multi-region replication delivers the required global distribution, while single-digit-millisecond reads and writes satisfy the low-latency constraint. The SQL API queries semi-structured documents directly, unlike fixed-schema relational services.
- ✗
Azure Data Lake Storage Gen2
Why it's wrong here
Azure Data Lake Storage Gen2 is object storage optimised for batch analytics, not low-latency point reads, and its hierarchical namespace does not deliver globally distributed query serving. It is tempting for schema-on-read JSON landing zones, and would be correct for a data lake feeding analytical pipelines.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database enforces a fixed relational schema, so evolving JSON structures require migrations rather than schema-on-write flexibility. It is tempting because it offers low latency and geo-replication, and would be correct for structured transactional data with stable columns, not semi-structured documents.
About these practice questions
Courseiva writes every DP-203 question from scratch — 509 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 →
Same concept, more angles
1 more way this is tested on DP-203
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. You need to store semi-structured JSON data from a web application that requires low-latency reads and writes at a global scale. The data must be indexed automatically and support SQL-like queries. Which Azure data store should you use?
easy- A.Azure SQL Database
- B.Azure Blob Storage
- ✓ C.Azure Cosmos DB (NoSQL API)
- D.Azure Table Storage
Why C: Azure Cosmos DB with the NoSQL API is the correct choice because it natively stores semi-structured JSON documents, provides automatic indexing of all properties, supports SQL-like queries via its query engine, and offers low-latency reads and writes at global scale through multi-region replication and configurable consistency levels. This combination directly matches the requirements for a globally distributed web application needing fast, queryable JSON storage.
You might also like
Similar DP-203 questions
- You are tasked with designing a data storage solution for a social media analytics company. They need to store user prof…
- Your company is migrating an on-premises SQL Server database to Azure SQL Database. The database includes a large fact t…
- A company is designing a data storage solution for IoT device telemetry data. The data is append-only, needs to be store…
- A data engineering team is designing a batch processing pipeline that reads from Azure Data Lake Storage Gen2, transform…
- You are designing a data storage solution in Azure Synapse Analytics dedicated SQL pool. The solution must support effic…
Written by Johnson Ajibi, MSc IT Security
Security Systems Architect · founder of Courseiva
This DP-203 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-203 exam.