DP-300 Certification Practice Question #245

Question

You have an Azure SQL database named SQL1.

You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:

•	The recovery point objective (RPO)
•	The recovery time objective (RTO)
•	Administrative effort

What should you include in the solution?

Accepted Answer

While both Active Geo-replication (B) and Auto-failover groups (D) provide replication to another Azure region with a low RPO (5 seconds) and RTO (30 seconds for manual failover), Auto-failover groups are the only solution that supports *automatic failover* managed by Azure. Active Geo-replication requires manual user intervention to initiate a failover (higher administrative effort). Thus, Auto-failover groups best satisfy all three constraints of minimizing RPO, RTO, and administrative effort.

More DP-300 practice questions