DP-300 Certification Practice Question #146

Question

You have an Azure SQL database named DB1 in the General Purpose service tier.

You need to monitor DB1 by using SQL Insights.

What should you include in the solution? To answer, select the appropriate options in the
 answer area.

Accepted Answer

SQL Insights (preview) uses a dedicated monitoring virtual machine that has the Azure Monitor Agent and Workload Insights (WLI) extension installed. The VM remotely collects data from the SQL resources. The collected data is stored in a Log Analytics workspace (not Azure Storage or Azure SQL DB). While the Azure Monitor Agent runs *on* the VM, the question's answer option is "A virtual machine" — which is the infrastructure component you create/configure, and the agent runs within it. All high-upvote commenters and MS Learn agree on VM + Log Analytics workspace.

More DP-300 practice questions