DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
You need to configure a backup policy for Azure SQL Database that allows restoring to any point within the last 7 days. What is the minimum point-in-time restore retention period you should set?
⚠ Common exam trap
DP-300 often tests the distinction between the default retention (7 days) and the configurable range (1-35 days), causing candidates to pick a value that is either too short or assumes the default is the only option.
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
✓
7 days
Azure SQL Database supports point-in-time restore (PITR) with a configurable retention period between 1 and 35 days, with a default of 7 days. To allow restoring to any point within the last 7 days, the minimum retention period that satisfies the requirement is exactly 7 days. Setting a shorter period (1 or 3 days) would not meet the stated requirement, and 14 days exceeds the minimum 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.
- ✗
1 day
Why it's wrong here
One day retains only 24 hours of point-in-time backups, so restores beyond that window are impossible. It is tempting because it is the smallest configurable value and minimises storage cost, but it fails the seven-day requirement. It would be correct only if the recovery window were a single day.
- ✓
7 days
Why this is correct
A 7-day point-in-time restore retention period satisfies the stem's requirement to restore to any point within the last 7 days, since Azure SQL Database's minimum configurable PITR retention is exactly 7 days. Setting 7 days meets the constraint without exceeding it, making it the minimum valid value.
- ✗
14 days
Why it's wrong here
Fourteen days exceeds the seven-day requirement, and Azure SQL Database bills for the configured retention, so it adds cost without benefit. It is tempting because longer retention appears safer, but the question asks for the minimum satisfying seven days. It would be correct if the requirement were fourteen days.
- ✗
3 days
Why it's wrong here
Three days covers only 72 hours of point-in-time restores, leaving days four through seven unrecoverable. It is tempting because it is a low-cost middle setting, but it still falls short of the stated seven-day window. It would be correct if the requirement were three days.
Go deeper
Related to this question
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 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.