Exam 70-762 topic 1 question 149 discussion

Actual exam question from Microsoft's 70-762

Question #: 149
Topic #: 1

You have multiple queries that take a long time to complete.
You need to identify the cause by using detailed information about the Transact-SQL statements in the queries. The Transact-SQL statements must not run as part of the analysis.
Which Transact-SQL statement should you run?

A. SET STATISTICS PROFILE OFF
B. SET SHOWPLAN_TEXT OFF
C. SET SHOWPLAN_ALL ON
D. SET STATISTICS PROFILE ON

Show Suggested Answer

Suggested Answer: C 🗳️
SET SHOWPLAN_ALL ON causes Microsoft SQL Server not to execute Transact-SQL statements. Instead, SQL Server returns detailed information about how the statements are executed and provides estimates of the resource requirements for the statements.
Incorrect Answers:
D: When STATISTICS PROFILE is ON, each executed query returns its regular result set, followed by an additional result set that shows a profile of the query execution.
Displays the profile information for a statement. STATISTICS PROFILE works for ad hoc queries, views, and stored procedures.
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-showplan-all-transact-sql

by lh2607 at Nov. 19, 2020, 10:56 a.m.

Comments

Submit Cancel

lh2607

Highly Voted 4 years, 5 months ago

Correct

upvoted 5 times

...

Exam 70-762 All Questions

View all questions & answers for the 70-762 exam

Exam 70-762 topic 1 question 149 discussion

Comments

lh2607

SY0-701