SIMULATION You need to configure a weekly backup of an Azure SQL database named Homepage. The backup must be retained for eight weeks. To complete this task, sign in to the Azure portal. Answer: You…

Submitted by diego_uy· Mar 6, 2026Implement and manage data platform resources - specifically configuring backup and recovery options for Azure SQL Database, aligning with the Azure Database Administrator Associate (DP-300) or Azure Administrator Associate (AZ-104) certification objectives around data protection and storage management.

Question

SIMULATION You need to configure a weekly backup of an Azure SQL database named Homepage. The backup must be retained for eight weeks. To complete this task, sign in to the Azure portal. Answer: You need to configure the backup policy for the Azure SQL database. 1. In the Azure portal, type Azure SQL Database in the search box, select Azure SQL Database from the search results then select Homepage. Alternatively, browse to Azure SQL Database in the left navigation pane. 2. Select the server hosting the Homepage database and click on Manage backups. 3. Click on Configure policies. 4. Ensure that the Weekly Backups option is ticked. 5. Configure the How long would you like weekly backups to be retained option to 8 weeks. 6. Click Apply to save the changes.

Explanation

The correct approach uses Azure SQL Database's built-in Long-Term Retention (LTR) policy, which allows administrators to configure weekly, monthly, and yearly backup retention beyond the default 7-35 day window. By navigating to the database's server, selecting 'Manage backups,' and configuring the weekly retention policy to 8 weeks, the administrator leverages Azure's native backup infrastructure without needing third-party tools or manual scripts. This is the only method that directly addresses both the frequency (weekly) and retention (8 weeks) requirements within the Azure portal.

Topics

#Azure SQL Database#Long-Term Retention (LTR)#Backup Policy#Data Protection

Community Discussion

No community discussion yet for this question.

Full AZ-500 Practice