You have an Azure SQL managed instance named SQL1. You need to configure a backup solution for SQL1. The solution must ensure that database backups can be retained for up to 10 years. Which two…

The correct answer is B. an Azure Storage account C. a long-term backup retention policy. In Azure SQL Managed Instance, you can configure a long-term backup retention policy (LTR). This allows you to automatically retain database backups in separate Azure Blob storage containers for up to 10 years. You can then recover a database using these backups with the Azure…

Submitted by ngozi_ng· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment

Question

You have an Azure SQL managed instance named SQL1. You need to configure a backup solution for SQL1. The solution must ensure that database backups can be retained for up to 10 years. Which two resources can you include in the solution? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options

Aa Recovery Services vault
Ban Azure Storage account
Ca long-term backup retention policy
Da policy in Azure Backup

How the community answered

(57 responses)

A
14% (8)
B
79% (45)
D
7% (4)

Explanation

In Azure SQL Managed Instance, you can configure a long-term backup retention policy (LTR). This allows you to automatically retain database backups in separate Azure Blob storage containers for up to 10 years. You can then recover a database using these backups with the Azure portal, the Azure CLI and PowerShell. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/long-term-backup-retention-

Topics

#SQL Managed Instance#long-term retention#Azure Storage#backup policy

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice