nerdexam
MicrosoftMicrosoft

AZ-500 · Question #172

AZ-500 Question #172: Real Exam Question with Answer & Explanation

Sign in or unlock AZ-500 to reveal the answer and full explanation for question #172. The question stem and answer options stay visible for context.

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.

Options

  • taskConfigure a weekly backup of an Azure SQL database named Homepage, which must be retained for eight weeks.
  • prerequisitesSign in to the Azure portal.

Unlock AZ-500 to see the answer

You've previewed enough free AZ-500 questions. Unlock AZ-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Azure SQL Database#Long-Term Retention (LTR)#Backup Policy#Data Protection
Full AZ-500 PracticeBrowse All AZ-500 Questions