DP-300 · Question #355
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…
The correct answer is D. SQL Insights. To implement a centralized monitoring solution for various Azure SQL resources with minimal administrative effort, SQL Insights should be used.
Question
Options
- ALog Analytics
- BAzure SQL Analytics
- CQuery Performance Insight
- DSQL Insights
How the community answered
(64 responses)- A2% (1)
- B2% (1)
- C3% (2)
- D94% (60)
Why each option
To implement a centralized monitoring solution for various Azure SQL resources with minimal administrative effort, SQL Insights should be used.
Log Analytics is a general-purpose logging service and would require significant configuration to achieve a centralized SQL monitoring solution compared to SQL Insights.
Azure SQL Analytics is an older solution that has largely been superseded by SQL Insights for comprehensive monitoring.
Query Performance Insight focuses specifically on query performance for individual Azure SQL Databases and does not provide centralized monitoring for all specified resource types.
SQL Insights provides a comprehensive, centralized monitoring solution for all Azure SQL resources including Azure SQL databases, SQL Managed Instances, and SQL Server on Azure Virtual Machines, integrating with Azure Monitor and minimizing administrative overhead.
Concept tested: Azure SQL centralized monitoring solution
Source: https://learn.microsoft.com/en-us/azure/azure-monitor/insights/sql-insights-overview
Community Discussion
No community discussion yet for this question.