You have SQL Server on an Azure virtual machine. The databases are written to nightly as part of a batch process.
You need to recommend a disaster recovery solution for the data. The solution must meet the following requirements:
✑ Provide the ability to recover in the event of a regional outage.
✑ Support a recovery time objective (RTO) of 15 minutes.
✑ Support a recovery point objective (RPO) of 24 hours.
✑ Support automated recovery.
✑ Minimize costs.
What should you include in the recommendation?

A. Azure virtual machine availability sets

B. Azure Disk Backup

C. an Always On availability group

D. Azure Site Recovery








 

Suggested Answer: D

Replication with Azure Site Recover:
✑ RTO is typically less than 15 minutes.
✑ RPO: One hour for application consistency and five minutes for crash consistency.
Incorrect Answers:
B: Too slow.
C: Always On availability group RPO: Because replication to the secondary replica is asynchronous, there's some data loss.
Reference:
https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql

This question is in AZ-305 Exam
For getting Azure Solutions Architect Expert Certificate