Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Your company hosts a mission-critical Azure SQL Database single database in the East US region. Compliance requires that you can restore the database to any point in time within the last 35 days. Business-continuity guidelines state that if the entire region becomes unavailable, the application must resume service in the paired region within minutes and with an RPO of less than five seconds, without manual intervention. You need to design the backup and disaster-recovery solution while keeping administrative effort low. Which Azure capability should you recommend?
Create an auto-failover group that replicates the database to a secondary server in the paired region.
Configure automatic geo-backup and perform geo-restore when needed.
Enable zone-redundant configuration for the database.
Schedule nightly exports of the database to Azure Storage and re-import after a failure.
An auto-failover group asynchronously replicates Azure SQL databases to a secondary server in a different region, typically keeping data lag under five seconds (meeting the RPO target) and enabling automatic failover within minutes (meeting the RTO target) with minimal operational overhead. Point-in-time restore for up to 35 days remains available because automated backups continue on both primary and secondary. Geo-restore based only on automated backups can have an RPO of up to one hour and requires manual action. Zone redundancy protects only against availability-zone failures inside the same region, not a regional outage. Nightly exports to Azure Storage are manual, increase management overhead, and can lose up to 24 hours of data, violating the RPO 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 an auto-failover group in Azure SQL Database?
Open an interactive chat with Bash
How does asynchronous replication work in auto-failover groups?
Open an interactive chat with Bash
What is the difference between geo-backup/geo-restore and auto-failover groups?
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 .