Plan and configure a high availability and disaster recovery environment →easyMultiple ChoiceObjective-mapped
DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
You are planning a disaster recovery strategy for an Azure SQL Database that is used by a non-critical application. The database is in the Standard tier. You need to minimize cost while ensuring the database can be restored to a different region within 12 hours of a regional disaster. 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
✓
Use geo-restore from geo-redundant backups.
Geo-redundant backup storage (RA-GRS) is automatically enabled for databases in the Standard tier, allowing geo-restore to any region within 12 hours. Option A is wrong because active geo-replication is not available in Standard tier. Option C is wrong because failover groups require Premium or Business Critical. Option D is wrong because cross-region replication is a setting for backup storage, not a separate feature.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable cross-region replication on the database.
Why it's wrong here
Cross-region replication is not a feature; geo-redundant backup storage is automatically configured.
- ✓
Use geo-restore from geo-redundant backups.
Why this is correct
Geo-restore is available for Standard tier and meets the 12-hour requirement.
- ✗
Configure active geo-replication to a secondary region.
Why it's wrong here
Active geo-replication is not available in Standard tier.
- ✗
Create a failover group with the secondary in a paired region.
Why it's wrong here
Failover groups require Premium or Business Critical tier.
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
Courseiva writes every DP-300 question from scratch — 906 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 →
Same concept, more angles
1 more way this is tested on DP-300
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Refer to the exhibit. You are reviewing an ARM template for deploying an Azure SQL Database. The template specifies a point-in-time restore from a source database. The source database is configured with geo-redundant backup storage. You need to ensure that the restored database can be used for disaster recovery in a different region. What is missing from the template to achieve this?
medium- A.Add a 'location' property to the database resource.
- B.Set 'zoneRedundant' to true.
- C.Change 'requestedBackupStorageRedundancy' to 'GeoZone'.
- ✓ D.Set 'createMode' to 'GeoRestore' and specify a target server in the desired region.
Why D: To perform a point-in-time restore in a different region for disaster recovery, you must set 'createMode' to 'GeoRestore' and specify the target server in the desired region. The template currently uses 'PointInTimeRestore', which only restores to the same region. Option A is incorrect because adding a 'location' property alone does not enable cross-region restore—the restore mode must be changed. Option B is incorrect because 'zoneRedundant' refers to high availability within a single region, not disaster recovery across regions. Option C is incorrect because 'GeoZone' backup redundancy still does not support cross-region point-in-time restore; geo-restore uses geo-redundant backups automatically.
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.