Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Your company hosts an Azure App Service application that uses an Azure SQL Database in the East US region. Leadership wants the data tier to remain available if the entire region becomes unavailable. The solution must provide automatic failover to another region, expose a single read-write listener endpoint so no code changes are required, and meet a recovery point objective (RPO) of five minutes or less. Which Azure feature should you implement?
Enable active geo-replication for the database and manually update connection strings during a disaster.
Configure an Azure SQL Database auto-failover group between an East US primary and a Central US secondary.
Migrate the database to SQL Server on two Azure virtual machines in different availability zones and configure an Always On failover cluster instance.
Move the database into an elastic pool that has zone redundancy enabled in East US.
Auto-failover groups for Azure SQL Database replicate one or more databases to a secondary region using geo-replication. They continuously synchronize changes with a recovery point objective of typically five minutes or less. The feature provides automatic failover when the primary region becomes unavailable and publishes a DNS-based read/write listener endpoint that stays constant, so applications do not need connection-string changes. Active geo-replication alone requires manual failover and connection-string updates, zone-redundant deployment only protects within a single region, and SQL Server Always On FCI on VMs meets high availability but lacks the built-in managed listener and adds administrative overhead. Therefore, configuring an auto-failover group is the correct choice.
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 Azure SQL Database auto-failover group?
Open an interactive chat with Bash
How does auto-failover differ from active geo-replication for Azure SQL Database?
Open an interactive chat with Bash
What is an RPO, and why is it important for Azure SQL Database failover features?
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 .