The answer is Long-term retention (LTR) for backups. Azure SQL Database’s default point-in-time restore (PITR) only retains backups for 7 days, which falls far short of the 7-year regulatory compliance requirement for financial applications. Long-term retention (LTR) is specifically designed for long-term backup retention, allowing you to store full database backups for up to 10 years by configuring a backup policy in the Azure portal or via T-SQL. On the DP-900 exam, this question tests your understanding of the difference between operational backup retention (PITR) and compliance-driven retention (LTR). A common trap is confusing PITR’s configurable range (1–35 days) with the multi-year retention needed for regulations like HIPAA or SOX. Remember the memory tip: “PITR is for short-term recovery; LTR is for long-term records.”
DP-900 Practice Question: Identify considerations for relational data on Azure
This DP-900 practice question tests your understanding of identify considerations for relational data on azure. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A company uses Azure SQL Database for a financial application. Regulatory compliance requires that database backups be retained for 7 years. The current configuration uses the default point-in-time restore (PITR) retention of 7 days. Which Azure SQL Database feature should the company enable to meet the 7-year retention requirement?
Correct. LTR allows keeping full database backups for years, meeting the 7-year compliance requirement.
B
Active geo-replication
Why wrong: Incorrect. Geo-replication provides readable replicas in another region for high availability, not extended backup retention.
C
Auto-failover groups
Why wrong: Incorrect. Auto-failover groups build on geo-replication for automated failover but do not increase backup retention periods.
D
Geo-redundant backup storage
Why wrong: Incorrect. While Azure SQL Database backups are automatically geo-redundant (RA-GRS) at the default PITR retention, that retention is still only 7 days without LTR.
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Long-term retention (LTR) for backups
Azure SQL Database's default point-in-time restore (PITR) retains backups for only 7 days, which is insufficient for the 7-year regulatory requirement. Long-term retention (LTR) allows you to retain full database backups for up to 10 years by configuring backup policies in the Azure portal or via T-SQL, meeting the compliance need.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✓
Long-term retention (LTR) for backups
Why this is correct
Correct. LTR allows keeping full database backups for years, meeting the 7-year compliance requirement.
Related concept
Read the scenario before looking for a memorised answer.
✗
Active geo-replication
Why it's wrong here
Incorrect. Geo-replication provides readable replicas in another region for high availability, not extended backup retention.
✗
Auto-failover groups
Why it's wrong here
Incorrect. Auto-failover groups build on geo-replication for automated failover but do not increase backup retention periods.
✗
Geo-redundant backup storage
Why it's wrong here
Incorrect. While Azure SQL Database backups are automatically geo-redundant (RA-GRS) at the default PITR retention, that retention is still only 7 days without LTR.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates confuse geo-redundant storage (which improves durability) with long-term retention (which extends the retention period), leading them to pick Option D instead of A.
Detailed technical explanation
How to think about this question
LTR backups are taken as full database backups weekly, differential backups daily, and transaction log backups every 5–10 minutes, stored in separate Azure Blob Storage containers. The retention policy is defined using a granular weekly, monthly, or yearly schedule, and you can restore to any point within the LTR window by combining these backups with PITR logs. A real-world scenario is a financial audit requiring a database snapshot from 5 years ago, which LTR can provide while PITR alone cannot.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this DP-900 question in full detail.
Identify considerations for relational data on Azure — This question tests Identify considerations for relational data on Azure — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Long-term retention (LTR) for backups — Azure SQL Database's default point-in-time restore (PITR) retains backups for only 7 days, which is insufficient for the 7-year regulatory requirement. Long-term retention (LTR) allows you to retain full database backups for up to 10 years by configuring backup policies in the Azure portal or via T-SQL, meeting the compliance need.
What should I do if I get this DP-900 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
This DP-900 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-900 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.