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





Previous Questions Next Questions