DP-300 Certification Practice Question #153

Question

You have five instances of SQL Server on Azure Virtual Machines.

You need to monitor Microsoft SQL Server performance for all the instances by consolidating metrics into a single graphic display. The solution must minimize administrative effort.

What should you use?

Accepted Answer

Although Azure Monitor (Option A) is the parent service and is selected as the suggested and most voted answer, SQL Insights (Option C) is the specific, purpose-built feature within Azure Monitor designed to monitor SQL Server performance across multiple instances (including SQL Server on Azure VMs) and consolidate metrics into a single graphic display (via Azure Monitor Workbooks). Using SQL Insights minimizes administrative effort by providing pre-built dashboards and collections rather than requiring custom setup in Azure Monitor.

More DP-300 practice questions