How to centrally monitor all Azure SQL resources?
Short answer
D SQL Insights
Question
Key Takeaways
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.
Common mistake: 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.
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
- https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql
- https://learn.microsoft.com/en-us/previous-versions/azure/azure-monitor/insights/azure-sql
These links open the official vendor documentation in a new tab.
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.
Community Votes
80% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 5 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 5
-
JJJR 👍 3 Answered DAnswer 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
-
2f5c7cd 👍 1 Answered DSQL 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"
-
voodoo_sh 👍 1Azure 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.
-
bingomutant 👍 1definitely D , for the stated reasons below
-
Vitos25 👍 1 Answered Bmy Vote B
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.
Related Analysis
Practice All DP-300 Questions
Access 105 questions with complete answers and detailed explanations.
View Full DP-300 Practice Test →