Describe considerations for working with non-relational data on Azure →mediumMultiple ChoiceObjective-mapped
DP-900 Practice Question: Describe considerations for working with non-relational data on Azure
A startup is building a global user session store. Each session consists of a simple key (session ID) and a value (user data as a JSON string). The application requires low-latency reads and writes from any Azure region, and the data must be durable. Which Azure service is best suited for this scenario?
⚠ Common exam trap
Many candidates confuse Azure Table Storage (a simple, regional key-value store) with Azure Cosmos DB Table API (a globally distributed, low-latency, SLA-backed service), assuming both offer the same global performance and durability, when in fact only Cosmos DB provides multi-region writes and guaranteed latency.
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 (Table API)
Azure Cosmos DB (Table API) is the best fit because it provides global, multi-region writes with tunable consistency, guaranteed single-digit-millisecond latency for reads and writes at the 99th percentile, and full durability with automatic replication across any number of Azure regions. The Table API offers a key-value store interface (session ID as partition key, JSON value) while also supporting schema flexibility and SLA-backed performance, which is critical for a global user session store.
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 (Table API)
Why this is correct
Azure Cosmos DB with the Table API is a globally distributed, fully managed NoSQL key-value store that offers single-digit-millisecond reads and writes at any scale. It provides automatic turnkey multi-region replication with multiple consistency models and active-active multi-region writes, making it ideal for a session store that must be accessible with low latency worldwide. The service guarantees 99.999% availability and elastic horizontal scaling, so session data remains durable and highly available without manual partitioning or failover management.
- ✗
Azure Table Storage
Why it's wrong here
Azure Table Storage is a cost-effective key-value store but is not globally distributed by default. Achieving global distribution would require complex application-level replication, and latency would not be as low as Cosmos DB across regions.
- ✗
Azure Redis Cache
Why it's wrong here
Azure Redis Cache is an in-memory data store, excellent for caching but not designed for durable storage. Data can be lost on node failure unless persistence is configured, and it does not natively support global distribution across regions.
- ✗
Azure Blob Storage
Why it's wrong here
Azure Blob Storage is an object storage service tailored for massive unstructured data such as images, videos, and log files, not for high-frequency point lookups by a session key. Its hierarchical namespace and REST API are designed for streaming and bulk operations, and it lacks built-in secondary indexes or low-latency key-value access patterns; each session lookup would require a full blob GET with overhead. Additionally, Blob Storage does not natively provide sub-millisecond multi-region read/write consistency, and achieving global distribution requires CDN caching or manual replication, which cannot guarantee the strong consistency and write durability that a user session store demands.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Azure Cosmos DB
Azure Cosmos DB is a fully managed, globally distributed NoSQL database service that offers fast reads and writes anywhere in the world with automatic scaling and multiple consistency models.
Key term
Table
A table is a structured collection of data organized into rows and columns, used in databases and spreadsheets to store and manage information efficiently.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.