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…

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.

Explanation

The correct answer walks through the precise Azure portal workflow to enable Advanced Data Security at the database level for SQLdb1, which includes navigating to the Security section, enabling ADS, configuring a storage account for audit logs, and entering the recipient email address under Advanced Threat Protection Settings. This sequence is necessary because ATP alerts must be explicitly configured with a destination email address - simply enabling ADS alone does not automatically route alerts to a specific user. Saving the configuration ensures all settings are persisted and active.

Topics

#Azure SQL Database Security#Advanced Data Security#Advanced Threat Protection#Azure Portal Configuration

Community Discussion

No community discussion yet for this question.

Full AZ-500 Practice