Plan and configure a high availability and disaster recovery environment →mediumMultiple ChoiceObjective-mapped
DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
You have an Azure SQL Database that is part of a failover group with automatic failover. The primary region experiences a complete outage. The failover group automatically fails over to the secondary region. After the primary region is restored, you need to ensure the database is operational in the primary region with minimal data loss. What should you do?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Initiate a manual failover of the failover group back to the primary region.
After automatic failover occurs, the database is now hosted in the secondary region. When the primary region is restored, you must initiate a manual failover to make the primary region the new primary again. This ensures minimal data loss because the failover group synchronizes data during the manual failover. Option B is incorrect because Azure SQL Database does not support automatic failback; you must manually fail over. Option C is incorrect because restoring from geo-redundant backup would result in data loss and is not necessary. Option D is incorrect because deleting and recreating the failover group could cause data loss and is not the recommended procedure.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Initiate a manual failover of the failover group back to the primary region.
Why this is correct
Manual failback re-establishes the primary in the original region with zero data loss.
- ✗
Wait for automatic failback to occur.
Why it's wrong here
Automatic failback is not supported; you must manually fail back.
- ✗
Restore the database from a geo-redundant backup.
Why it's wrong here
Restoring from backup would lose transactions committed after the last backup.
- ✗
Delete the failover group and recreate it with the original primary as the new primary.
Why it's wrong here
This would cause data loss and downtime.
Visual reference
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.