Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Contoso ingests billions of semi-structured IoT telemetry events each hour. You plan to store the data by using Azure Cosmos DB with the Core (SQL) API. The solution must:
guarantee 99.999 percent read and write availability even if an Azure region becomes unavailable,
provide automatic failover without code changes, and
keep write latency as low as possible for users worldwide. Which design should you recommend?
Create a Cosmos DB account that has multi-region writes enabled, add the required Azure regions, and configure automatic failover with a prioritized region list.
Provision Azure SQL Database in two regions, configure an active geo-replication pair, and enable automatic failover groups for high availability.
Create a single-write-region Cosmos DB account, replicate it to additional regions, and use Azure Traffic Manager with performance routing to direct clients; trigger failover manually when needed.
Deploy Azure Table storage accounts in two Azure regions with geo-redundant storage replication (RA-GRS) and implement client-side retry logic for failover.
Enabling multi-region writes on an Azure Cosmos DB account and turning on automatic failover satisfies all the stated requirements. Multi-region write accounts receive a 99.999 percent SLA for both reads and writes and can continue serving traffic from any healthy region if one becomes unavailable. Because every configured region can accept writes, users around the world write to the nearest region, minimizing latency.
The alternative designs fail to meet one or more requirements:
A single-write-region Cosmos DB account-even with additional read regions-offers only a 99.99 percent write-availability SLA. Although such an account can be configured for automatic failover, it still falls short of the 99.999 percent availability target.
Azure Table storage with geo-redundant replication guarantees only 99.9 percent write availability and relies on client-side retry logic for failover.
Azure SQL Database with active geo-replication provides a 99.99 percent availability SLA, which does not meet the 99.999 percent requirement.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is multi-region writes in Azure Cosmos DB?
Open an interactive chat with Bash
How does automatic failover work in Azure Cosmos DB?
Open an interactive chat with Bash
Why is Azure Cosmos DB better than Azure SQL Database or Azure Table storage for this scenario?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design business continuity solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .