Microsoft Exam 70-762 Topic 13 Question 3 Discussion

Actual exam question for Microsoft's 70-762 exam

Question #: 3
Topic #: 13

You use Microsoft SQL Server Profile to evaluate a query named Query1. The Profiler report indicates the following issues:

- At each level of the query plan, a low total number of rows are processed.

- The query uses many operations. This results in a high overall cost for the query.

You need to identify the information that will be useful for the optimizer.

What should you do?

AStart a SQL Server Profiler trace for the event class Auto Stats in the Performance event category.

BCreate one Extended Events session with the sqlserver.missing_column_statistics eventadded.

CStart a SQL Server Profiler trace for the event class Soft Warnings in the Errors and Warnings event category.

DCreate one Extended Events session with the sqlserver.missing_join_predicate event added.

Show Suggested Answer

Suggested Answer: D

The Missing JoinPredicate event class indicates that a query is being executed that has no join predicate. This could result in a long-running query.

by Lorrie at May 03, 2022, 01:18 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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