DP-300 · Question #311
DP-300 Question #311: Real Exam Question with Answer & Explanation
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 A
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
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.