DP-203 Design and implement data storage Practice Question
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?
⚠ Common exam trap
Candidates often confuse Azure Table Storage's key-value capabilities with Cosmos DB's document model, mistakenly thinking Table Storage supports SQL-like queries and automatic indexing, when in fact it only supports OData queries and requires explicit partition and row keys for efficient access.
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 (NoSQL API)
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.
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 SQL Database
Why it's wrong here
Azure SQL Database stores relational data with a fixed schema, so semi-structured JSON needs shredding or JSON functions rather than native document indexing. It suits transactional relational workloads; a document-oriented store with automatic indexing fits this scenario.
- ✗
Azure Blob Storage
Why it's wrong here
Azure Blob Storage offers no automatic indexing or SQL-like query engine over JSON; queries require external compute such as Synapse or Databricks. It suits cheap bulk storage of unstructured objects, not low-latency global reads and writes with queryable indexing.
- ✓
Azure Cosmos DB (NoSQL API)
Why this is correct
Azure Cosmos DB (NoSQL API) natively stores semi-structured JSON documents, automatically indexes every property without schema definitions, and offers single-digit-millisecond latency with global multi-region distribution. Its SQL-like query syntax over the NoSQL API satisfies the stem's requirements for automatic indexing, low-latency reads and writes at global scale, and SQL-like querying.
- ✗
Azure Table Storage
Why it's wrong here
Azure Table Storage is a key-attribute NoSQL store without secondary indexing or SQL-like querying, and its global replication options are limited. It suits cheap high-volume key-based lookups, not semi-structured JSON requiring automatic indexing and SQL-like queries at global scale.
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 →
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.