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…

The correct answer is D. auto-failover groups. https://learn.microsoft.com/en-us/azure/azure-sql/database/business-continuity-high-availability- disaster-recover-hadr-overview?view=azuresql Recovery method RTO RPO Geo-restore from geo-replicated backups 12 h 1 h Auto-failover groups 1 h 5 s Manual database failover 30 s 5 s…

Submitted by diego_uy· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment

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?

Options

AAzure Site Recovery
Bactive geo-replication
Cavailability groups
Dauto-failover groups

How the community answered

(34 responses)

A
3% (1)
B
3% (1)
C
9% (3)
D
85% (29)

Explanation

https://learn.microsoft.com/en-us/azure/azure-sql/database/business-continuity-high-availability- disaster-recover-hadr-overview?view=azuresql Recovery method RTO RPO Geo-restore from geo-replicated backups 12 h 1 h Auto-failover groups 1 h 5 s Manual database failover 30 s 5 s Auto fail over groups gives the lesser RPO&RTO and less administrative effor than manual fail

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice