DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
You manage an Azure SQL Database in the East US region. The database uses the General Purpose service tier with geo-redundant backup storage. You need to ensure that in the event of a regional outage, you can restore the database to the West US region with the least possible downtime. What should you use?
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 active geo-replication to a secondary server in West US.
Active geo-replication to a secondary server in West US is the correct choice because it maintains a continuously synchronized secondary database in the target region, enabling a fast failover with minimal downtime if the primary region fails. Geo-restore can restore to West US from geo-redundant backups, but it has a much longer recovery time than failing over to an already synchronized secondary. Creating a copy-only backup and manually transferring it is slow and not automated. Point-in-time restore is limited to the same region and cannot restore directly to West US.
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 to a secondary server in West US.
Why this is correct
Active geo-replication must be configured proactively.
- ✗
Use the geo-restore feature to restore from the geo-redundant backups to a new database in West US.
Why it's wrong here
Geo-restore uses the geo-redundant backup and can restore to any region.
- ✗
Create a copy-only backup and manually transfer it to West US.
Why it's wrong here
Copy-only backup is not a standard DR procedure and would be slower.
- ✗
Perform a point-in-time restore to a new database in West US.
Why it's wrong here
Point-in-time restore is limited to the same region.
Visual reference
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.
About these practice questions
This DP-300 question is part of Courseiva's 574-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.