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 Managed Instance configured with a failover group between two regions. The primary region becomes unavailable. You need to fail over to the secondary 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
✓
Run 'az sql mi failover-group force-failover-allow-data-loss' from the Azure CLI
During a disaster where the primary region is unavailable, the correct action is to force a failover with potential data loss. The Azure CLI command 'az sql mi failover-group force-failover-allow-data-loss' (Option A) performs this forced failover, accepting the risk of data loss to restore availability. Option B is incorrect because adding to an elastic pool is unrelated to failover groups. Option C is incorrect because 'az sql mi failover-group failover' is not a valid command; the correct command includes 'force-failover-allow-data-loss'. Option D is incorrect because the Azure portal does not directly support geo-failover for managed instances; the CLI or PowerShell must be used for forced failover.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Run 'az sql mi failover-group force-failover-allow-data-loss' from the Azure CLI
Why this is correct
This command forces failover to the secondary, accepting potential data loss due to unreplicated transactions.
- ✗
Add the secondary instance to an elastic pool and initiate failover
Why it's wrong here
Azure SQL Managed Instance does not use elastic pools; this is for Azure SQL Database.
- ✗
Run 'az sql mi failover-group failover' from the Azure CLI
Why it's wrong here
'failover' is a planned failover command that requires the primary to be accessible; it will fail if the primary is down.
- ✗
Use Azure portal to initiate geo-failover for the managed instance
Why it's wrong here
The Azure portal does not offer a direct failover action for managed instances; you must use PowerShell or CLI.
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
One of 906 original DP-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.