Microsoft Certified Azure Database Administrator Associate · Free Practice Question Medium
Question 6
What should you review to understand how SQL Server executed a specific query and which part of the query took time? (Select the best answer)
- A Server Logs
- B SQL Insights Dashboard
- C Execution Plans
- D Resource Governor
Reveal correct answer
Correct answer: C
Explanation
Execution plans show exactly how SQL Server went about getting the data for a query, making them invaluable for performance tuning. URL: https://docs.microsoft.com/en-us/sql/relational-databases/performance/execution-plansDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
