nerdexam
MicrosoftMicrosoft

AZ-500 · Question #176

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

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

Submitted by tunde_lagos· Mar 6, 2026Implement and manage security for Azure SQL databases, including configuring Advanced Data Security and Advanced Threat Protection alert notifications - aligning with the AZ-500 'Secure Data and Applications' domain or SC-300/AZ-104 security management objectives.

Question

SIMULATION You need to enable Advanced Data Security for the SQLdb1 Azure SQL database. The solution must ensure that Azure Advanced Threat Protection (ATP) alerts are sent to [email protected]. To complete this task, sign in to the Azure portal and modify the Azure resources. Answer: 1. In the Azure portal, type SQL in the search box, select SQL databases from the search results then select SQLdb1. Alternatively, browse to SQL databases in the left navigation pane. 2. In the properties of SQLdb1, scroll down to the Security section and select Advanced data security. 3. Click on the Settings icon. 4. Tick the Enable Advanced Data Security at the database level checkbox. 5. Click Yes at the confirmation prompt. 6. In the Storage account select a storage account if one isn't selected by default. 7. Under Advanced Threat Protection Settings, enter [email protected] in the Send alerts to box. 8. Click the Save button to save the changes.

Options

  • taskEnable Advanced Data Security for the SQLdb1 Azure SQL database and ensure that Azure Advanced Threat Protection (ATP) alerts are sent to [email protected].
  • prerequisitesSign in to the Azure portal and modify the Azure resources.

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 Security#Advanced Data Security#Advanced Threat Protection#Azure Portal Configuration
Full AZ-500 PracticeBrowse All AZ-500 Questions