DP-300 Certification Practice Question #207

Question

SIMULATION
 -

You need to generate an email alert to admin@contoso.com when CPU percentage utilization for db1 is higher than average.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

To monitor CPU utilization on Azure SQL Database `db1` and notify an administrator when utilization is higher than average, you should configure an Azure Monitor alert rule at the database resource level. In the Azure portal, navigate to the `db1` database pane and under **Monitoring**, select **Alerts** to create a new alert rule. The condition should use the **CPU percentage** metric, configured with a **Dynamic** threshold (which dynamically detects anomalies by comparing current usage to the historical average baseline). Finally, configure or associate an **Action Group** configured with an **Email** notification action pointing to `admin@contoso.com`.

More DP-300 practice questions