Plan and configure a high availability and disaster recovery environment →hardMultiple SelectObjective-mapped
DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
Which THREE of the following are required considerations when configuring a failover group for Azure SQL Managed Instance?
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
✓
Both instances must be in the same partner region pair.
Options A, C, and E are correct. For Azure SQL Managed Instance failover groups, both instances must be in the same partner region pair (e.g., East US and West US). The secondary instance must be in a different Azure region to provide geo-redundancy. The databases must be in the same resource group. Option B is incorrect because the secondary instance can have a different service tier than the primary. Option D is incorrect because automatic failover is not required; you can use manual 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.
- ✓
Both instances must be in the same partner region pair.
Why this is correct
Correct: Failover groups require partner regions.
- ✗
Both instances must have the same service tier.
Why it's wrong here
Incorrect: They can have different service tiers.
- ✓
The secondary instance must be in a different Azure region.
Why this is correct
Correct: For disaster recovery, the secondary must be in a different region.
- ✗
Automatic failover must be enabled.
Why it's wrong here
Incorrect: Automatic failover is optional; manual failover is also supported.
- ✓
The databases must be in the same resource group.
Why this is correct
Correct: All databases in a failover group must be in the same resource group.
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
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.