Exam DP-300 topic 6 question 47 discussion

Answer is C. Azure Site Recovery RTO comparison with BCDR options: https://learn.microsoft.com/en-us/azure/site-recovery/site-recovery-sql#combining-bcdr-technologies-with-site-recovery Performing Isolated disaster recovery tests: https://learn.microsoft.com/en-us/azure/site-recovery/site-recovery-test-failover-to-azure However, Site Recovery is not automatic, as it must be initiated manually. We can however use scripts and runbooks to automate tasks during failover. The second link also describes this. Incorrect: Active geo-replication - Is a feature of Azure SQL Database and is not for VM's Auto-failover Groups - Is a feature of Azure SQL Database and Managed Instance, not for VM's. A Failover cluster instance - Does provide automated failover to another node in the cluster, and the node can be located in another region. But it does not provide a way to perform DR in an isolated environment.

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. Reference: https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql