You have an Azure subscription that contains a Basic SKU Azure SQL database named DB1. You need to configure the long-term retention of backups for DB1. The solution must maximize how long the backups

The correct answer is D. 10 years. Long-term retention - Azure SQL Database and Azure SQL Managed Instance Long-term retention can be configured for up to 10 years on backups for Azure SQL Database (including in the Hyperscale service tier), and Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/a

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

Question

You have an Azure subscription that contains a Basic SKU Azure SQL database named DB1. You need to configure the long-term retention of backups for DB1. The solution must maximize how long the backups are retained. Which retention period should you configure?

Options

A180 days
B365 days
Cfive years
D10 years

How the community answered

(42 responses)

A
12% (5)
B
5% (2)
C
10% (4)
D
74% (31)

Explanation

Long-term retention - Azure SQL Database and Azure SQL Managed Instance Long-term retention can be configured for up to 10 years on backups for Azure SQL Database (including in the Hyperscale service tier), and Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention- overview?view=azuresql

Topics

#long-term retention#Basic tier#Azure SQL Database#backup policy

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice