DP-300 Certification Practice Question #193

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?

Accepted Answer

MS Learn explicitly states that metric alerts for individual databases in a SQL Managed Instance are NOT available — only instance-level metrics can be alerted on. Per-database alerting must be done through diagnostics logs. Azure SQL Analytics consumes these diagnostics log streams and provides alert capabilities (SQLInsights, QueryStoreRuntime, Errors, etc.) per-database. Therefore **D — Azure SQL Analytics alerts based on diagnostics logs** is the correct answer. Option A is wrong because individual database metric-based alerts are not supported for MI. Options B and C reference "SQL Health Check," which is not an Azure Monitor/SQL service.

More DP-300 practice questions