Microsoft
DP-300 · Question #318
You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implement a disaster recovery solution that meets the following requirements: - Returns the solution to an…
The correct answer is C. 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. Always On availability group RPO: Because replication to the secondary replica is asynchronous, there's some data…
Submitted by alyssa_d· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment
Question
You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implement a disaster recovery solution that meets the following requirements: - Returns the solution to an operational state within 15 minutes of a failure - Can perform disaster recovery testing in an isolated environment - Minimizes administrative effort What should you include in the solution?
Options
- Aactive geo-replication
- Bauto-failover groups
- CAzure Site Recovery
- Da failover cluster instance (FCI)
How the community answered
(23 responses)- A17% (4)
- B4% (1)
- C74% (17)
- D4% (1)
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. 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.