Posted by: Pdfprep
Post Date: October 30, 2021
You have an Azure SQL database.
You identify a long running query.
You need to identify which operation in the query is causing the performance issue.
What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
A . Live Query Statistics
B . an estimated execution plan
C . an actual execution plan
D . Client Statistics
Answer: C
Explanation:
To include an execution plan for a query during execution
Leave a Reply