Administering Relational Databases on Microsoft Azure — Question 7

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?

Answer options

• A. Resource Groups
• B. SQL Servers
• C. SQL Databases
• D. SQL Virtual Machines

Correct answer: C

Explanation

The correct answer is C, SQL Databases, because alerts for CPU usage need to be set at the database level to monitor and respond to performance metrics. Options A and B are too broad, as resource groups and SQL servers encompass multiple databases, while option D, SQL Virtual Machines, is unrelated to Azure SQL Database monitoring.