Question

A financial services company runs a critical application on Azure SQL Managed Instance. The compliance team requires the ability to restore the database to any point in time within the last 28 days to recover from accidental data corruption caused by application bugs. The architect must ensure this capability is configured with the least administrative overhead and no additional third-party tooling. Which approach should the architect recommend?

Accepted Answer

Configure the point-in-time restore (PITR) backup retention period on the managed instance to 28 days.

Answer

Create a Recovery Services vault and configure Azure Backup with a daily backup policy retained for 28 days.

Answer

Set up a long-term retention (LTR) policy on the managed instance to keep weekly backups for 4 weeks.

Answer

Deploy a scheduled Azure Automation runbook that exports BACPAC files to Blob Storage every night and retains them for 28 days.