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 solu...
Microsoft AZ-305 Exam
Questions Number: 102 out of 268 Questions
38.06%
Question 102
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?
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