QuestionQ77

VerifiedMonitor, configure, and optimize database resources

You have several Azure SQL databases on the same Azure SQL Database server in a resource group called ResourceGroup1.

You must receive an alert when CPU utilization exceeds 80 percent for any database. The solution must apply to any additional databases created on the Azure SQL server.

Which resource type should you use to create the alert?

Explanation

To alert on CPU exceeding 80% for any database, including databases created later, you create the Azure Monitor metric alert scoped at the logical SQL server (resource type SQL servers / Microsoft.Sql/servers) rather than at each individual database. A server-scoped alert automatically evaluates all current and future databases on that server, satisfying the requirement to cover additional databases without creating new rules. Scoping to the resource group (choice A) would include unrelated resource types and would not cleanly target the databases' cpu_percent metric, and SQL Databases would have to be re-created per new database. So the correct resource type is SQL Servers.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!