Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You manage a business-critical single Azure SQL Database deployed in the East US 2 region. Compliance rules state that the application must remain available with an RPO under 5 seconds and an RTO of about one minute if the entire region becomes unavailable. The solution should require no code changes and keep the same database name after a failover. Which Azure feature should you implement to meet these requirements?
Rely on geo-restore from automated backups when a regional outage occurs.
Configure an auto-failover group with a secondary database in another Azure region.
Enable active geo-replication and plan a manual failover procedure.
Deploy the database with zone-redundant high availability within East US 2.
Auto-failover groups extend active geo-replication by adding a multi-region listener and automatic, policy-based failover. For single databases in the Business Critical tier it delivers an RPO of less than 5 seconds and can automatically fail over to a secondary in another region, keeping the same logical server name so connection strings need not change. Active geo-replication alone meets the RPO but requires manual redirection. Geo-restore relies on backups and has an RTO measured in hours, and zone-redundant configuration protects only against a datacenter outage within the same region, not a regional failure.
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 an auto-failover group in Azure SQL Database?
Open an interactive chat with Bash
What is RPO and RTO in the context of disaster recovery?
Open an interactive chat with Bash
How does active geo-replication differ from auto-failover groups?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design data storage 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 .