AZ-305 Design data storage solutions Practice Question
Which TWO of the following are benefits of using Azure Cosmos DB for a globally distributed application?
⚠ Common exam trap
Test-takers frequently confuse 'automatic failover' with 'no manual intervention required'—Azure Cosmos DB requires explicit configuration (enabling automatic failover and setting region priorities) for it to occur automatically, and even then, failover is not instantaneous and may involve a brief period of unavailability.
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
✓
Multiple well-defined consistency levels
Azure Cosmos DB offers multiple well-defined consistency levels (Strong, Bounded Staleness, Session, Consistent Prefix, Eventual) that allow developers to balance data consistency, availability, and latency according to application requirements. This flexibility is a key benefit for globally distributed applications because different operations may tolerate different levels of staleness while still meeting SLAs.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Multiple well-defined consistency levels
Why this is correct
Cosmos DB exposes five well-defined consistency levels—Strong, Bounded Staleness, Session, Consistent Prefix, and Eventual—giving you fine-grained control over the trade-off between data freshness and availability/latency. Unlike a fixed default, you can set the consistency level at the account or even at the individual request level, which is a core selling point for globally distributed workloads.
- ✗
Full support for SQL Server features like stored procedures
Why it's wrong here
While Cosmos DB does support server-side stored procedures, triggers, and user-defined functions, they are executed in JavaScript, not T-SQL, within the database engine. This is a long way from 'full SQL Server feature support' because Cosmos DB does not implement the complete relational query processor, correlated subqueries, or SQL Server's transaction management model. Thus the option overstates what the API actually provides.
- ✓
Turnkey global distribution across multiple Azure regions
Why this is correct
With a single click in the Azure portal, you can add or remove regions and Cosmos DB will transparently replicate all data to each new geography, a capability known as turnkey global distribution. The service manages the underlying replication, conflict resolution, and regional routing, allowing all regions to remain fully readable while the account continues to serve requests from anywhere in the world.
- ✗
Automatic failover to a secondary region without manual intervention
Why it's wrong here
Cosmos DB's service-managed failover does not happen automatically unless you explicitly enable the automatic failover setting on a single-region write account, and the failover order must be configured in advance. For accounts with multi-region writes, there is no secondary region to fail over to because every region can accept both reads and writes. Therefore the statement 'without manual intervention' is misleading: it ignores both the required configuration and the multi-region write model.
- ✗
Support for only the SQL API
Why it's wrong here
Although Cosmos DB's native API was originally SQL-like, the platform is multi-model and now exposes protocol-compatible endpoints for MongoDB, Cassandra, Azure Table Storage, and Gremlin (graph) on the same underlying data engine. This lets teams use familiar client drivers and query languages, so the claim that only the SQL API is supported is factually incorrect.
Go deeper
Related to this question
About these practice questions
One of 795 original AZ-305 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 AZ-305 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 AZ-305 exam.