DP-300 Certification Practice Question #275

Question

You have an instance of SQL Server on Azure Virtual Machine named SQL1.
You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize administrative effort.
Where should you store the metrics?

Accepted Answer

To store metrics and query them using Kusto Query Language (KQL) while minimizing administrative effort, a Log Analytics workspace is required. Log Analytics workspaces are the native repository for Azure Monitor Logs and are designed to store performance and diagnostic metrics, which are then queried directly using KQL. Other storage types such as Event Hubs, SQL Database, or Blob Storage do not support KQL queries out of the box.

More DP-300 practice questions