Courseiva

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 →

How Courseiva writes practice questions · Editorial policy

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

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.