DP-300 Certification Practice Question #192

Question

You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.
You need to implement alerts by using Azure Monitor. The solution must meet the following requirements:
✑ Minimize costs.
✑ Aggregate Intelligent Insights telemetry from each database.
What should you do?

Accepted Answer

MS Learn is unambiguous: the managed instance container has its own telemetry separate from each instance database's telemetry, and you must **separately** enable streaming for each instance database. The question specifically asks to aggregate Intelligent Insights telemetry **from each database**, which is the SQLInsights category available only on per-database diagnostic settings sent to **Log Analytics**. Event Hub (B, D) is designed for streaming to third-party systems, not for Azure Monitor alerting. Option C (SQLMI1 level) only captures ResourceUsageStats, not per-database Intelligent Insights. Therefore **A** — configuring diagnostic settings on each database and sending to Log Analytics — is correct and also minimizes costs versus a per-database event hub.

More DP-300 practice questions