A compliance team requires monthly backups kept for seven years and a yearly backup kept for ten years. Which Azure SQL feature should the DBA configure?
Show answer and explanation
Answer: D
Long-term backup retention lets the DBA set weekly, monthly and yearly retention policies, with the monthly and yearly copies kept for up to ten years. That matches the compliance schedule directly and is managed by the platform. Point-in-time restore retention is capped well below ten years. A BACPAC is a manual export that the team would schedule and manage itself, and geo-redundant storage replicates backups without changing how long they are kept.
Why the other options are wrong
- A. Point-in-time restore retention has a much shorter maximum than ten years, so it cannot meet the seven-year and ten-year requirements.
- B. A BACPAC is a manual export that the team would build and maintain itself. The platform's managed long-term retention is the feature this requirement refers to.
- C. Geo-redundant storage copies backups to another region. It does not change how long the monthly and yearly backups are retained.