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
You are designing a disaster recovery plan for an Azure SQL Managed Instance that hosts a financial application. The application requires an RPO of 0 seconds and an RTO of 30 seconds. Which TWO configurations meet these requirements? (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
✓
Deploy a Business Critical instance with zone redundancy and a failover group to a secondary instance in a paired region, using the Business Critical service tier.
Options C and D are correct. To achieve an RPO of 0 seconds and an RTO of 30 seconds for Azure SQL Managed Instance, you need configurations that provide synchronous replication and rapid failover. Option C combines zone redundancy (for local high availability with zero data loss within the region) and a failover group to a secondary instance in a paired region. The failover group, when used with the Business Critical service tier and a planned failover, can synchronize all data before failing over, meeting the zero RPO requirement. Option D directly uses a failover group with the 'planned' failover option, which ensures all committed transactions are replicated before failover, achieving zero data loss and a fast RTO. Option A is incorrect because active geo-replication is not supported for SQL Managed Instance and is asynchronous. Option B is incorrect because zone redundancy alone provides high availability within a single region but does not address cross-region disaster recovery. Option E is incorrect because manual restore from backup cannot meet the 30-second RTO.
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 active geo-replication between two Business Critical instances in different regions.
Why it's wrong here
Active geo-replication is not supported for Azure SQL Managed Instance and uses asynchronous replication, which cannot guarantee zero data loss.
- ✗
Deploy a zone-redundant Business Critical instance in a single region and rely on automatic failover.
Why it's wrong here
Zone redundancy provides high availability within a region but does not provide cross-region disaster recovery, so it cannot achieve the required RPO/RTO for regional failures.
- ✓
Deploy a Business Critical instance with zone redundancy and a failover group to a secondary instance in a paired region, using the Business Critical service tier.
Why this is correct
Combining zone redundancy with a failover group to a paired region using the Business Critical service tier ensures synchronous replication locally and for planned failover to the secondary region, meeting zero RPO and fast RTO.
- ✓
Use a failover group with the 'planned' failover option and a Business Critical secondary instance.
Why this is correct
A failover group with the 'planned' failover option triggers a synchronous replication of all data before failover, ensuring zero data loss and a rapid failover, meeting the RPO of 0 seconds and RTO of 30 seconds.
- ✗
Set up a manual failover process using a PowerShell script that restores from the latest backup.
Why it's wrong here
Manual restore from backup cannot meet the 30-second RTO as restoring a database takes significantly longer.
Visual reference
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.