DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
A company plans to migrate an on-premises SQL Server database to Azure SQL Database Managed Instance. They require a high availability solution that provides automatic failover between replicas within the same region with an RPO of 0 and an RTO of less than 30 seconds. Which service tier should they choose?
⚠ Common exam trap
DP-300 often tests the difference between General Purpose and Business Critical HA capabilities, and candidates may incorrectly assume Hyperscale or single database tiers offer the same sub-30-second RTO with zero RPO.
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
✓
Business Critical
Business Critical service tier in Azure SQL Managed Instance provides built-in high availability with multiple replicas and automatic failover, achieving an RPO of 0 and RTO typically under 30 seconds. It uses Always On availability groups under the hood with local redundant storage and supports read-only routing. This tier is designed for mission-critical workloads requiring the lowest latency and highest resilience.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Business Critical
Why this is correct
Business Critical uses Always On availability groups with multiple synchronous replicas in the same region, delivering zero data loss (RPO 0) and automatic failover typically under 30 seconds. Its local SSD and built-in read replica satisfy the stem's same-region, low-latency failover constraint, unlike General Purpose's single remote-storage replica.
- ✗
General Purpose
Why it's wrong here
General Purpose uses remote storage with a single primary and secondary replica; failover typically exceeds 30 seconds, so the RTO requirement is unmet. It is tempting as the default cost-effective tier for standard workloads without stringent failover timing.
- ✗
Azure SQL Database (single)
Why it's wrong here
Azure SQL Database (single) is a platform-as-a-service deployment, not a Managed Instance service tier, so it cannot satisfy the migration requirement. It is tempting because it offers built-in high availability, but the stem specifies Managed Instance.
- ✗
Hyperscale
Why it's wrong here
Hyperscale provides read-scale replicas and rapid restore, but its local high availability uses the same primary and secondary replica model with failover times that do not guarantee sub-30-second RTO. It is tempting for very large databases needing fast backup and scale-out reads.
Go deeper
Related to this question
Learn chapter
Deploying and Configuring SQL Server on Azure Virtual Machines
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
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 — 574 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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.