nerdexam
Microsoft

AZ-500 · Question #171

SIMULATION You need to ensure that the audit logs from the SQLdb1 Azure SQL database are stored in the WS11641655 Azure Log Analytics workspace. To complete this task, sign in to the Azure portal…

The correct steps navigate directly to the SQLdb1 database's Auditing settings under the Security section, which is the dedicated configuration area for directing audit logs to various destinations. Enabling auditing and selecting the Log Analytics option, then configuring it…

Submitted by omar99· Mar 6, 2026Configure and manage Azure security monitoring - specifically enabling and routing Azure SQL Database audit logs to a Log Analytics workspace for centralized log management and compliance reporting (AZ-500 / SC-900 / DP-300 Security and Compliance domain).

Question

SIMULATION You need to ensure that the audit logs from the SQLdb1 Azure SQL database are stored in the WS11641655 Azure Log Analytics workspace. 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 Auditing. 3. Turn auditing on if it isn't already, tick the Log Analytics checkbox then click on Configure. 4. Select the WS11641655 Azure Log Analytics workspace. 5. Click Save to save the changes.

Exhibit

AZ-500 question #171 exhibit

Explanation

The correct steps navigate directly to the SQLdb1 database's Auditing settings under the Security section, which is the dedicated configuration area for directing audit logs to various destinations. Enabling auditing and selecting the Log Analytics option, then configuring it to point to the WS11641655 workspace, establishes the integration between Azure SQL Database auditing and Azure Monitor Log Analytics. Saving the configuration ensures audit log data is continuously streamed to the specified workspace for centralized monitoring and analysis.

Topics

#Azure SQL Database#Database Auditing#Log Analytics Workspace#Azure Monitor

Community Discussion

No community discussion yet for this question.

Full AZ-500 Practice