Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You manage an e-commerce application that uses a single Azure SQL Database in the General Purpose tier (East US). A recent availability-zone outage made the database unavailable for 20 minutes. New requirements are:
Database must stay writable if any single zone in East US fails.
Recovery time after a zone failure must be under one minute.
Cross-region disaster recovery is not required.
No virtual-machine administration is acceptable.
Which change best meets these requirements?
Migrate to SQL Server on Azure Virtual Machines configured in an availability set.
Enable auto-failover groups between two Azure SQL Databases in different regions.
Configure active geo-replication to a secondary database in Central US.
Upgrade the database to the Business Critical service tier and enable zone-redundant configuration.
The Business Critical service tier for Azure SQL Database implements a four-replica Always On availability group. When zone redundancy is enabled, each replica is automatically placed in a different availability zone within the same region. If one zone fails, the service promotes a healthy replica in another zone-typically within 30 seconds-so the database remains online for both reads and writes, meeting the sub-minute RTO. Active geo-replication and auto-failover groups focus on cross-region recovery and do not guarantee sub-minute failover inside the primary region. Running SQL Server on Azure VMs in an availability set still leaves the workload vulnerable to a full zone outage and introduces VM management overhead. Therefore, upgrading to Business Critical and enabling zone redundancy satisfies all stated requirements.
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 the Business Critical service tier in Azure SQL Database?
Open an interactive chat with Bash
What is zone redundancy in Azure SQL Database?
Open an interactive chat with Bash
Why is cross-region disaster recovery not required in 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 .