A company is designing a data protection strategy for Azure SQL Database. They need to ensure that backups are retained for 7 years to meet regulatory compliance. Which Azure feature should they use?
Trap 1: Geo-redundant backup storage
Does not extend retention period.
Trap 2: Point-in-Time Restore
PITR max retention is 35 days.
Trap 3: Active Geo-Replication
Used for read-scale, not backup retention.
- A
Geo-redundant backup storage
Why wrong: Does not extend retention period.
- B
Long-Term Retention (LTR)
LTR retains backups for up to 10 years.
- C
Point-in-Time Restore
Why wrong: PITR max retention is 35 days.
- D
Active Geo-Replication
Why wrong: Used for read-scale, not backup retention.