DP-300 Configure and manage automation of tasks Practice Question
You are designing an automated backup strategy for Azure SQL Database. Which TWO actions satisfy a requirement to maintain daily backups for 30 days and ensure recoverability if the Azure region becomes unavailable?
⚠ Common exam trap
Many candidates confuse high-availability features (like geo-replication or read-scale replicas) with backup retention and storage redundancy, leading candidates to select options that provide failover capability but do not satisfy the backup retention or geo-redundant backup storage requirements.
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
✓
Enable geo-redundant backup storage for the server.
Enabling geo-redundant backup storage (RA-GRS) for Azure SQL Database ensures that automated backups are replicated to a paired Azure region. This satisfies the requirement for recoverability if the primary region becomes unavailable, as backups can be restored from the secondary region. Combined with setting point-in-time restore retention to 30 days (Option C), you maintain daily backups for the full 30-day retention period, meeting both requirements.
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 geo-redundant backup storage for the server.
Why this is correct
Geo-redundant backup storage (RA-GRS) replicates backups to a paired region, ensuring regional recoverability.
- ✗
Deploy a read-scale replica in a different Azure region.
Why it's wrong here
Read-scale replicas are for offloading read-only queries and do not provide backup retention.
- ✓
Set point-in-time restore retention to 30 days.
Why this is correct
PITR retention of 30 days keeps daily backups for that period, meeting the requirement.
- ✗
Set up a long-term retention policy with a retention of 30 days.
Why it's wrong here
LTR is intended for retaining backups beyond 35 days (e.g., monthly, yearly), not for daily backups within 30 days.
- ✗
Configure active geo-replication to a secondary region.
Why it's wrong here
Active geo-replication replicates the live database, not backups; it doesn't provide backup retention.
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 →
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.