DP-300 Configure and manage automation of tasks Practice Question
You are designing an automated backup strategy for Azure SQL Database. The compliance policy requires point-in-time restore (PITR) for the last 35 days, and long-term retention (LTR) for 7 years. What is the minimal number of LTR policies needed?
⚠ Common exam trap
A common pitfall is confusing LTR policy scope with elastic pool or server level. LTR is per database, not per server or pool.
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
✓
One LTR policy per database.
LTR policies are applied at the database level in Azure SQL Database. Each database requires its own LTR policy to retain backups beyond the PITR retention period. Option A is wrong because policies are per database, not per elastic pool. Option B is wrong because two policies per server (weekly and yearly) are not a minimal requirement; each database can have multiple LTR policies as needed. Option C is wrong because one LTR policy cannot cover all databases on a server; each database has its own retention 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.
- ✗
One LTR policy per elastic pool.
Why it's wrong here
LTR policies are not pool-scoped; they are per database.
- ✗
Two LTR policies per server (weekly and yearly).
Why it's wrong here
Even if different frequencies, they apply to each database individually.
- ✗
One LTR policy per server.
Why it's wrong here
LTR policies are defined at the database level, not server level.
- ✓
One LTR policy per database.
Why this is correct
Each database requires its own LTR policy to define retention periods.
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.
Key term
Azure SQL Database Backup
Azure SQL Database Backup is a fully managed, automated service that creates and stores copies of your SQL database data and transaction logs in Azure storage, enabling point-in-time recovery and long-term retention for data protection and business continuity.
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.