You need to design a backup solution for Azure SQL Database that will store backups that can be restored for up to 5 years. What solution will you recommend?
Experience Level: Senior
Tags: Azure CloudAzure SQL Database
Answer
Use Azure SQL long-term backup retention policy (LTR) to automatically retain backups in separate Azure Blob storage containers for up to 10 years.
You can then recover a database using these backups using the Azure portal or PowerShell. Long-term retention policies are also supported for Azure SQL Managed Instance.
Related Azure Cloud job interview questions
According to Microsoft Cloud Adoption Framework (CAF), what are the three specific terms related to Management phaze that can help improve conversations among business stakeholders?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are 6 key steps for establishing a management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat is management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are the 5 disciplines of cloud governance according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorIs Cloud Security Posture Management (CSPM) available for all Azure Subscriptions?
Microsoft Defender Junior