You have an Azure SQL managed instance that hosts multiple databases. You need to configure alerts for each database based on the diagnostics telemetry of the database. What should you use?

The correct answer is D. Azure SQL Analytics alerts based on diagnostics logs. You can use Azure SQL Analytics for monitoring and alerting. You can easily create alerts with the data coming from Azure SQL Database resources. Here are some useful log queries that you can use with a log alert: Example, HIGH CPU: | where ResourceProvider=="MICROSOFT.SQL" | whe

Submitted by tarun92· Mar 6, 2026Monitor, configure, and optimize database resources

Question

You have an Azure SQL managed instance that hosts multiple databases. You need to configure alerts for each database based on the diagnostics telemetry of the database. What should you use?

Options

AAzure SQL Analytics alerts based on metrics
BSQL Health Check alerts based on diagnostics logs
CSQL Health Check alerts based on metrics
DAzure SQL Analytics alerts based on diagnostics logs

How the community answered

(41 responses)

A
2% (1)
B
5% (2)
C
12% (5)
D
80% (33)

Explanation

You can use Azure SQL Analytics for monitoring and alerting. You can easily create alerts with the data coming from Azure SQL Database resources. Here are some useful log queries that you can use with a log alert: Example, HIGH CPU: | where ResourceProvider=="MICROSOFT.SQL" | where ResourceId contains "/DATABASES/" | where MetricName=="cpu_percent" | summarize AggregatedValue = max(Maximum) by bin(TimeGenerated, 5m) | render timechart Note: Azure Monitor Logs is based on Azure Data Explorer, and log queries are written using the same Kusto query language (KQL). https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging- streaming-export-configure?tabs=azure-portal#configure-the- streaming-export-of-diagnostic-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice