Plan and configure a high availability and disaster recovery environment →mediumMultiple SelectObjective-mapped
DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
You are designing a disaster recovery plan for an Azure SQL Managed Instance that hosts an OLTP application. The application requires an RPO of 15 seconds and an RTO of 5 minutes. You need to choose a configuration that meets these requirements. Which TWO options should you consider? (Choose two.)
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
✓
Configure a failover group with a secondary instance in a paired region, both using Business Critical service tier.
(failover group with Business Critical secondary in paired region) meets the RPO of 15 seconds and RTO of 5 minutes because Business Critical tier uses synchronous commit within the region and asynchronous replication across regions, with failover group providing automated failover. Option E (active geo-replication) is not supported for Azure SQL Managed Instance; only failover groups are available. Option B does not protect against regional failure. Option C's General Purpose tier cannot guarantee the required low RPO/RTO. Option D is not a standalone solution.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Configure a failover group with a secondary instance in a paired region, both using Business Critical service tier.
Why this is correct
Correct. Failover groups with Business Critical tier provide synchronous commit within the region and asynchronous replication across regions, enabling RPO of up to 5 seconds and RTO of approximately 1 minute, meeting the requirements.
- ✗
Deploy a zone-redundant Business Critical instance in a single region.
Why it's wrong here
Incorrect. Zone-redundant configuration only protects against zone failure within a region, not a full regional outage. Therefore it cannot meet the RTO of 5 minutes for a regional disaster.
- ✗
Deploy a General Purpose instance with a failover group to a secondary in another region.
Why it's wrong here
Incorrect. General Purpose tier uses asynchronous replication and slower storage, resulting in higher RPO and RTO than required.
- ✗
Ensure the secondary instance has at least one readable secondary replica.
Why it's wrong here
Incorrect. Ensuring a readable secondary is a property of a configuration, but by itself does not provide the necessary replication or failover capabilities to meet the RPO/RTO.
- ✗
Use active geo-replication between two Business Critical instances in different regions.
Why it's wrong here
Incorrect. Active geo-replication is not supported for Azure SQL Managed Instance. The appropriate cross-region DR feature is failover groups, not geo-replication.
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.