DP-300 Certification Practice Question #120

Question

You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.
You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure
SQL server.
Which resource type should you use to create the alert?

Accepted Answer

To monitor a database-specific metric like CPU usage (CPU percentage) across all databases on a logical server, including any future databases, you must configure a multi-resource metric alert in Azure Monitor. You achieve this by setting the resource type to **SQL databases** (Option C), and then setting the scope to the logical SQL server or resource group. This ensures that the alert rule dynamically applies to all databases (current and future) under that scope.

More DP-300 practice questions