Question

Difficulty: EasyAzure Monitor and Log Analytics

An organization hosts a customer database on an Azure SQL Database instance. The database administrator wants to track the database's real-time CPU consumption to ensure there is enough processing capacity. Which Azure service should the administrator use to collect and visualize these resource-level performance metrics?

  1. Azure MonitorAnswer
  2. B
    Azure Service Health
  3. C
    Azure Policy
  4. D
    Azure Arc

Answer

Azure Monitor
Azure Monitor is the correct service because it is specifically designed to collect, analyze, and visualize telemetry data, such as real-time CPU utilization metrics and diagnostic logs, from individual Azure resources like Azure SQL Database.

Step-by-Step Solution

1
Determine the monitoring requirement.
The requirement is to collect, track, and visualize real-time CPU performance telemetry for a specific database resource hosted inside Azure.
Identifying the scope of monitoring (individual resource performance vs. global service status) helps isolate the correct management service.
2
Evaluate the capabilities of the primary monitoring service.
Azure Monitor collects numeric performance metrics and logs from Azure resources, enabling administrators to analyze trends and set up alerts.
This matches the requirement to monitor and visualize database CPU consumption.
3
Rule out alternative management and governance services.
Azure Service Health tracks platform-wide events, Azure Policy enforces compliance standards, and Azure Arc handles hybrid resource management.
Ensures that other management tools are not confused with telemetry collection services.

Key Concept

Using Azure Monitor to collect and visualize performance metrics of Azure resources.
Rate this question