Plan and configure a high availability and disaster recovery environment →hardMultiple ChoiceObjective-mapped
DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
Your company uses Azure SQL Database with active geo-replication configured between two regions. The primary database in East US experiences a critical failure, and you initiate a manual failover to the secondary in West US. After the failover, you need to re-establish geo-replication to a new secondary database in a third region (Central US) to restore the DR capability. What is the correct sequence of actions?
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
✓
Remove the geo-replication link to the old primary, then add a new secondary in Central US.
After a manual failover, the former secondary becomes the new primary. The old primary, if still available, becomes a secondary. To restore DR capability with a new secondary in Central US, you must first remove the existing geo-replication link between the current primary and the old primary (the orphaned secondary). Without removing this link, you cannot add another secondary. Once the link is removed, you can create a new geo-secondary in Central US from the current primary. Therefore, option D is correct. Option A is incorrect because deleting the old primary is unnecessary and could be destructive. Option B is incorrect because a new secondary cannot be added while a geo-replication link already exists to the old primary. Option C is incorrect because performing a planned failover back to the old primary would cause unnecessary downtime and does not facilitate adding a secondary in Central US.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Delete the old primary and create a new geo-secondary in Central US.
Why it's wrong here
Deleting the old primary is unnecessary if it is still available; you can just remove the link.
- ✗
Add a new secondary in Central US on the current primary.
Why it's wrong here
You cannot add a new secondary while an existing secondary (the old primary) is still linked.
- ✗
Perform a planned failover to the old primary, then configure geo-replication to Central US.
Why it's wrong here
This would cause unnecessary downtime and is not required.
- ✓
Remove the geo-replication link to the old primary, then add a new secondary in Central US.
Why this is correct
Removing the old link allows you to create a new secondary on the current primary.
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
Courseiva writes every DP-300 question from scratch — 906 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.