az-104 Practice Question 1750
Exam: az-104
Domain: Monitor and maintain Azure resources
Topic: Monitor resources by using Azure Monitor
Difficulty: medium
Contoso Ltd has recently migrated their on-premises SQL Server to Azure SQL Database. They want to monitor the performance of the database using Azure Monitor. Which of the following actions should they take to set up a metric alert when the CPU usage exceeds 80% for more than 5 minutes?
Answer Options
A
Create a Log Analytics workspace and query the SQL Server logs for CPU usage.
B
Set up a metric alert in Azure Monitor with a threshold of 80% CPU usage for more than 5 minutes.
C
Use Log Analytics to create a query that monitors the SQL Server performance counters and set up an alert based on the results.
D
Write a custom script to monitor the SQL Server performance and send an email notification when the CPU usage exceeds 80%.
Correct Answer
B: Set up a metric alert in Azure Monitor with a threshold of 80% CPU usage for more than 5 minutes.
Explanation
The correct answer is B because it involves setting up an Azure Monitor metric alert with the appropriate threshold and duration. Option A is incorrect as it does not specify the metric to be monitored. Option C is incorrect because it mentions Log Analytics, which is not necessary for setting up a metric alert. Option D is incorrect as it suggests using a custom script, which is not required for this task.