Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-300 Topic 7 Question 17 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 17
Topic #: 7
[All DP-300 Questions]

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)?

Show Suggested Answer Hide Answer
Suggested Answer: C

To include an execution plan for a query during execution

1. On the SQL Server Management Studio toolbar, click Database Engine Query. You can also open an existing query and display the estimated execution plan by clicking the Open File toolbar button and locating the existing query.

2. Enter the query for which you would like to display the actual execution plan.

3. On the Query menu, click Include Actual Execution Plan or click the Include Actual Execution Plan toolbar button.

Note: Actual execution plans are generated after the Transact-SQL queries or batches execute. Because of this, an actual execution plan contains runtime information, such as actual resource usage metrics and runtime warnings (if any). The execution plan that is generated displays the actual query execution plan that the SQL Server Database Engine used to execute the queries.

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!

Save Cancel