What should you include in the recommendation?

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

View Answer

Answer: D

Explanation:

Replication with Azure Site Recover:

✑ RTO is typically less than 15 minutes.

✑ RPO: One hour for application consistency and five minutes for crash consistency.

Reference: https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql