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
You have an Azure SQL Managed Instance configured with a failover group for disaster recovery. The primary instance is in the East US region and the secondary is in West US. You need to perform a planned failover for maintenance with zero data loss. What is the correct sequence of steps?
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
✓
Use the Azure portal to perform a planned failover for the failover group.
To perform a planned failover with zero data loss for an Azure SQL Managed Instance failover group, you should use the Azure portal (or PowerShell/CLI) to initiate a planned failover. This ensures that all transactions are synchronized before switching roles, preventing data loss. Option A is incorrect because taking the primary offline before failover would cause downtime and potential data loss. Option C is incorrect because scaling down does not facilitate a planned failover. Option D is incorrect because removing the failover group would break replication and is unnecessary.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Take the primary instance offline, then failover.
Why it's wrong here
Incorrect: Taking offline would cause data loss.
- ✓
Use the Azure portal to perform a planned failover for the failover group.
Why this is correct
Correct: A planned failover ensures zero data loss.
- ✗
Scale down the primary to reduce cost, then failover.
Why it's wrong here
Incorrect: Scaling down does not help with maintenance.
- ✗
Remove the failover group, perform maintenance, then recreate the failover group.
Why it's wrong here
Incorrect: This would cause downtime and potential data loss.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed cloud database service that gives you nearly all the features of Microsoft SQL Server on your own server, without you having to manage the hardware or operating system.
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.