dp-300 Practice Question 2010
Exam: dp-300
Domain: Monitor and optimize operational resources
Topic: Monitor activity and performance
Difficulty: medium
You are tasked with monitoring the performance of an Azure SQL Database instance over a period of time to ensure it meets the required service level agreements (SLAs). You need to set up a monitoring solution that can capture detailed performance metrics and alert you when certain thresholds are exceeded. Which feature would best suit this requirement?
Answer Options
A
Intelligent Insights
B
Query Performance Insight
C
Extended Events
D
Automatic Tuning
Correct Answer
C: Extended Events
Explanation
The correct answer is C. Extended Events can be configured to capture detailed performance metrics over extended periods, allowing for long-term monitoring and historical analysis. Intelligent Insights and Query Performance Insight are more focused on providing real-time insights and recommendations, while Automatic Tuning is designed to automatically optimize database performance based on observed workload patterns.