DP-900 Practice Question: Identify considerations for relational data on Azure
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?
⚠ Common exam trap
Watch out — candidates often 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.
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
✓
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.
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
Long-term retention (LTR) enables you to retain full database backups for up to 10 years (or a custom period) in a separate storage container, independent of the automated point-in-time restore (PITR) backups. LTR policies are defined at the database or server level and can specify weekly, monthly, or yearly backup schedules. Because LTR stores these full backups in a dedicated vault and allows restores to any specific point within the retention window, it directly satisfies the 7-year compliance requirement for financial data.
- ✗
Active geo-replication
Why it's wrong here
Active geo-replication creates a continuously updated, readable secondary database in a different Azure region, but it is designed for high availability and disaster recovery, not for historical backup retention. The secondary database contains only the current data state as replicated from the primary; it does not keep point-in-time snapshots or a chain of backups. While geo-replication protects against regional outages and can provide read scalability, it cannot be used to restore data from years ago, so it does not address compliance retention.
- ✗
Auto-failover groups
Why it's wrong here
Auto-failover groups build on active geo-replication by grouping multiple databases and providing an automatic, policy-based failover endpoint in the event of a regional outage. Although this feature improves availability SLAs and simplifies failover coordination, it does not alter the underlying backup retention policies or preserve historical data beyond the standard PITR window. The failover process switches to another replica but does not create long-lived backup copies, so it is irrelevant to meeting a 7-year compliance requirement.
- ✗
Geo-redundant backup storage
Why it's wrong here
Geo-redundant backup storage (RA-GRS) is an automatic feature of Azure SQL Database that replicates backup files to a paired Azure region for durability, ensuring backups survive a regional disaster. However, geo-redundancy only refers to the resilience of the stored backup copies, not to the length of time they are kept — the default PITR retention is only 7 days (configurable up to 35 days for some tiers). Even though the backups are copied to another region, they are still deleted after the configured retention period, so geo-redundant storage alone cannot provide the seven years of archival history required for compliance.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DP-900 question from scratch — 820 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-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.