DP-300 Practice Question: Plan and configure high availability and disaster recovery
Which THREE factors should be considered when choosing between Azure SQL Database active geo-replication and auto-failover groups for disaster recovery?
⚠ Common exam trap
Test-takers frequently assume a lower RPO is always a deciding factor, but both technologies provide the same RPO, so the key differentiators are automatic failover, the number of readable secondaries, and granular failover control.
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
✓
Automatic failover capability
Auto-failover groups provide automatic failover capability, which is essential for minimizing downtime during a disaster. Active geo-replication, on the other hand, requires manual or custom scripting to initiate failover, making it less suitable for scenarios where rapid, unattended recovery is needed.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Automatic failover capability
Why this is correct
Auto-failover groups provide automatic failover; active geo-replication does not.
- ✗
Recovery Point Objective (RPO) of 1 second
Why it's wrong here
Both have RPO of 5 seconds.
- ✓
Number of readable secondary replicas required
Why this is correct
Active geo-replication supports up to 4, auto-failover groups support only 1.
- ✗
Support for SQL Server Authentication
Why it's wrong here
Both support SQL Server Authentication.
- ✓
Granular control over individual database failover
Why this is correct
Active geo-replication allows per-database failover; auto-failover groups fail over all databases in the group.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
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.
About these practice questions
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.