Courseiva
Design and implement data storageeasyMultiple ChoiceObjective-mapped

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

    Table Storage is a NoSQL key-value store but lacks the global distribution and low-latency guarantees of Cosmos DB.

  • Azure Cosmos DB

    Why this is correct

    Cosmos DB natively supports JSON documents with automatic indexing and global distribution.

  • Azure Data Lake Storage Gen2

    Why it's wrong here

    Data Lake Storage is for big data analytics, not low-latency operational queries.

  • Azure SQL Database

    Why it's wrong here

    Azure SQL Database requires a defined schema, not ideal for evolving JSON data.

About these practice questions

Courseiva writes every DP-203 question from scratch — 760 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.

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · 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.