dp-300 Practice Question 2009
Exam: dp-300
Domain: Monitor and optimize operational resources
Topic: Monitor activity and performance
Difficulty: medium
In an Azure SQL Database environment, you notice that a specific query is running slowly and causing performance issues. You want to gather detailed information about the query execution plan and identify potential bottlenecks. Which tool or feature should you use to achieve this?
Answer Options
A
Intelligent Insights
B
Query Performance Insight
C
Automatic Tuning
D
Extended Events
Correct Answer
B: Query Performance Insight
Explanation
The correct answer is B. Query Performance Insight provides detailed insights into query performance, including execution plans, wait statistics, and resource usage. It helps identify the root cause of performance issues. Intelligent Insights and Automatic Tuning are broader tools that provide monitoring and tuning recommendations across multiple resources, while Extended Events are used for more granular event tracking but not specifically for query performance analysis.