You have an Azure subscription that contains a Standard SKU Azure SQL database named DB1. You need to enable point-in-time recovery (PITR) backups for DB1. The solution must maximize how long the…

The correct answer is B. 35 days. Backup storage (point-in-time restore) By default, seven days of database backups are stored in RA-GRS Standard blob storage. The retention period can be increased to up to 35 days. The Azure SQL Database service protects all databases with an automated backup system. These…

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

Question

You have an Azure subscription that contains a Standard SKU Azure SQL database named DB1. You need to enable point-in-time recovery (PITR) backups for DB1. The solution must maximize how long the backups are retained. Which retention period should you configure?

Options

Aseven days
B35 days
C180 days
D365 days

How the community answered

(47 responses)

A
4% (2)
B
81% (38)
C
13% (6)
D
2% (1)

Explanation

Backup storage (point-in-time restore) By default, seven days of database backups are stored in RA-GRS Standard blob storage. The retention period can be increased to up to 35 days. The Azure SQL Database service protects all databases with an automated backup system. These backups are retained for 7 days for Basic, 35 days for Standard and 35 days for Premium. https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single https://azure.microsoft.com/en-us/blog/azure-sql-database-point-in-time-restore/

Topics

#PITR#backup retention#Standard tier#Azure SQL Database

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice