nerdexam
MicrosoftMicrosoft

AZ-500 · Question #171

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

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

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.

Options

  • taskEnsure that the audit logs from the SQLdb1 Azure SQL database are stored in the WS11641655 Azure Log Analytics workspace.
  • prerequisitesAzure portal access

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#Database Auditing#Log Analytics Workspace#Azure Monitor
Full AZ-500 PracticeBrowse All AZ-500 Questions