DP-300 Certification Practice Question #154

Question

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 implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort.

What should you include in the solution?

Accepted Answer

To monitor a heterogeneous SQL estate consisting of Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure VMs from a centralized solution, SQL Insights (Option D) is the correct choice. SQL Insights (preview) is the only native Azure monitoring service listed that supports all three resource types. Azure SQL Analytics (Option B) is incorrect because it does not support SQL Server on Azure VMs. Query Performance Insight (Option C) is incorrect because it is restricted to Azure SQL Database. Log Analytics (Option A) is the underlying data repository rather than the monitoring interface.

More DP-300 practice questions