DP-900 Describe core data concepts Practice Question
A company is designing a data solution for their e-commerce platform. They need to store product catalogs with varying attributes, support high-throughput read/write operations, and ensure low-latency access globally. Which Azure data store is most appropriate?
⚠ Common exam trap
Candidates often confuse Azure SQL Database's JSON support with native schema flexibility, overlooking the fact that Cosmos DB is purpose-built for globally distributed, schema-agnostic workloads with guaranteed latency SLAs.
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 most appropriate choice because it is a globally distributed, multi-model database service that supports schema-agnostic storage of product catalogs with varying attributes. It offers guaranteed single-digit-millisecond latency for reads and writes at any scale, and its turnkey global distribution enables low-latency access from multiple regions, meeting the e-commerce platform's high-throughput and global requirements.
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
Why this is correct
Azure Cosmos DB is a multi-model NoSQL database service that provides turnkey global distribution, single-digit-millisecond read and write latencies at the 99th percentile, and automatic indexing of all data without requiring a predefined schema. For an e-commerce product catalog, this means product attributes, variants, and pricing can evolve freely while data is replicated across Azure regions using multiple consistency models to serve customers globally. Its SLA-backed availability and multi-master write support make it the right operational store for always-on transactional catalog workloads.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a relational database engine that enforces a fixed schema through tables, columns, and constraints, so adding a new product attribute such as a custom size or color would require a schema change and a migration. While you can enable active geo-replication or failover groups, these features are separate from the database itself and cannot match Cosmos DB's write-anywhere multi-master replication without considerable extra configuration and management. This rigidity makes it less agile for an e-commerce catalog whose product shapes change rapidly.
- ✗
Azure Redis Cache
Why it's wrong here
Azure Redis Cache is an in-memory key-value store built on Redis and is intended to be a caching layer that temporarily holds frequently accessed data to speed up reads. It does not provide durable primary storage guarantees like a real database—data lives in RAM and can be lost on restart unless persistence is explicitly configured, and even then it is not a globally distributed transactional store. Using it as the authoritative product catalog would risk data loss, inventory inconsistency, and no strong consistency controls during failover.
- ✗
Azure Data Lake Storage
Why it's wrong here
Azure Data Lake Storage is a hyperscale blob repository designed for batch and interactive analytics over petabytes of structured and semi-structured data, not for high-frequency point reads and writes on individual product records. Its access pattern is built around scanning large datasets with tools like Azure Synapse or Spark, and its per-operation latency and cost model are ill-suited to serving a live e-commerce catalog to end users. It also lacks the single-digit-millisecond write latency, automatic indexing, and multi-region transactional capabilities an operational database requires.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Service
A service is a software component or system that performs a specific function and is available to be used by other programs or users over a network.
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
About these practice questions
Courseiva writes every DP-900 question from scratch — 820 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-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.