DP-300 Certification Practice Question #248

Question

You have an Azure SQL database.

You need to implement a disaster recovery solution that meets the following requirements:

•	Minimizes how long it takes to recover the database if a datacenter fails
•	Minimizes administrative effort

What should you include in the solution?

Accepted Answer

Auto-failover groups (C) minimize both the recovery time (RTO) and administrative effort by allowing Azure SQL to automatically detect a regional datacenter outage and fail over a group of databases to a secondary region. While Active Geo-replication (B) also replicates data, it requires manual administrative action to trigger failover, resulting in higher administrative effort. Therefore, Auto-failover groups are the best solution.

More DP-300 practice questions