How to centrally monitor all Azure SQL resources?

You have an Azure subscription that contains the following resources: • 10 Azure SQL databases • Five Azure SQL managed instances • Five instances of SQL Server on Azure Virtual Machines You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort. What should you include in the solution?

  1. Log Analytics
  2. Azure SQL Analytics
  3. Query Performance Insight
  4. SQL Insights Source Reference Answer

Community Votes

D
80%
B
20%

80% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The exam tests your ability to select a single monitoring solution that spans all Azure SQL deployment types, with the common trap being Azure SQL Analytics which does not support SQL Server on Azure VMs.

Centralized monitoring across Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs requires SQL Insights, which provides a unified telemetry and visualization experience. Community consensus strongly supports SQL Insights as the only option covering all three resource types.

Many candidates choose Azure SQL Analytics (Option B) because it is a well-known monitoring tool, but it cannot monitor SQL Server running on Azure Virtual Machines, making it an incomplete solution.

Community Discussion (5 comments)

voodoo_sh 👍 1
Azure SQL Analytics can't monitor SQL Server on Azure VM - https://learn.microsoft.com/en-us/previous-versions/azure/azure-monitor/insights/azure-sql Because of this, pick D - SQL Insights. So question might be outdated.
2f5c7cd 👍 1 Selected: D
SQL insights offers you a flexible canvas for telemery collection, analysis, and rich custom visualization. You can customize telemetry collection and frequency, and also combine data from multiple sources into a single monitoring experience for your entire SQL estate. SQL insights is enterprise-ready and easily scales to meet your resource requirements. This feature is available in preview for SQL Database, SQL Managed Instance and SQL Server on Azure Virtual Machines. But not for long "SQL Insights (preview) will be retired on 31 December 2024"
bingomutant 👍 1
definitely D , for the stated reasons below
Vitos25 👍 1 Selected: B
my Vote B
JJJR 👍 3 Selected: D
Answer is D. SQL Insights is the only option that monitors SQL Server on Azure VM, Azure SQL Database and Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

SQL Insights (now evolved into Azure SQL Analytics in Azure Monitor) is designed to provide a unified monitoring experience across Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs. It offers a flexible telemetry canvas for collection, analysis, and custom visualization across the entire SQL estate. As community member [1] notes, it is the only option that covers all three resource types mentioned in the question.

Why the Other Options Are Wrong

Log Analytics (Option A) is the underlying data platform but is not a purpose-built SQL monitoring solution by itself. Query Performance Insight (Option C) only applies to Azure SQL Database and does not cover Managed Instances or SQL Server on VMs. Azure SQL Analytics (Option B) historically could not monitor SQL Server on Azure VMs, which community member [2] correctly identifies as the disqualifying factor.

Community Comment Notes

The vote distribution (80 for D, 20 for B) reflects the common confusion between SQL Insights and Azure SQL Analytics. Comment [3] highlights SQL Insights' enterprise-ready scalability and multi-source data aggregation capabilities. Comment [2] correctly points out that the question may be slightly outdated as Microsoft has since rebranded and consolidated these monitoring features under Azure Monitor.

Official Reference

Exam Strategy

When a question requires monitoring multiple Azure SQL deployment types (Database, Managed Instance, and SQL on VM), always look for the solution that explicitly covers all three. Eliminate options that only work for specific SQL deployment types like Query Performance Insight or Azure SQL Analytics.

Related Analysis

Case study - This is a case study. Case studies are not time

S-Grade

Case study - This is a case study. Case studies are not time

A-Grade

You have an Azure subscription. You plan to provision a sing

A-Grade

Practice All DP-300 Questions

Access 105 questions with complete answers and detailed explanations.

View Full DP-300 Practice Test →

← Back to DP-300 Study Guide