nerdexam
Microsoft

AZ-305 · Question #37

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…

The correct answer is D. Azure Site Recovery. 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: C: Always On availability group RPO: Because replication to the secondary replica is asynchronous…

Submitted by miguelv· Mar 6, 2026Design business continuity solutions

Question

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?

Options

  • AAzure virtual machine availability sets
  • BAzure Disk Backup
  • Can Always On availability group
  • DAzure Site Recovery

How the community answered

(48 responses)
  • A
    8% (4)
  • B
    23% (11)
  • C
    6% (3)
  • D
    63% (30)

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. Incorrect Answers: C: Always On availability group RPO: Because replication to the secondary replica is asynchronous, there's some data loss. https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-305 Practice