Register to Better Coder! It's free.
Enjoy the premium features and succeed at every job interview.
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
You need to recommend a disaster recovery solution for your Azure SQL database that needs to remain available even when the whole region fails. What should you include in the recommendation?
Azure CloudAzure SQL Database SeniorYou need to recommend a disaster recovery solution for your Azure CosmosDB database that needs to remain available even when the whole region fails. What should you include in the recommendation?
Azure CloudAzure Cosmos DB SeniorWhat is a difference between Azure SQL Database vCore and DTU purchase model?
Azure CloudAzure SQL Database SeniorYou want to use Azure Hybrid Benefit (AHB) for Azure SQL Database. What purchase model can you use it with?
Azure CloudAzure SQL Database SeniorWhat is Azure SQL Database vCore purchase model?
Azure CloudAzure SQL Database Senior