SQL Server runs on an Azure virtual machine and databases are written nightly by a batch job. Design a disaster recovery solution that provides automated recovery for a regional outage, supports an RTO of 15 minutes and an RPO of 24 hours, and minimizes cost. Which solution should you include?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Site Recovery.
Why this is the answer
Azure Site Recovery (ASR) is the correct choice because it provides automated disaster recovery for Azure VMs, meeting the RTO of 15 minutes by orchestrating replication and failover to a secondary region. The RPO of 24 hours is easily achievable with ASR's replication policies. ASR is also cost-effective for disaster recovery compared to maintaining a full standby environment. Azure virtual machine availability sets provide high availability within a single data center, not regional disaster recovery. Azure Disk Backup offers point-in-time recovery for disks but doesn't provide automated, orchestrated failover for VMs in a regional outage. SQL Server Always On availability groups would provide high availability and disaster recovery for the SQL Server itself, but ASR is needed to protect the entire VM and its applications, not just the database.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed