Microsoft
70-768 · Question #38
You use Microsoft SQL Server Profile to evaluate a query named Query. The Profiler report indicates the following issues: - At each level of the query plan, a low total number of rows are processed…
The correct answer is D. Create one Extended Events session with the sqlserver.missing_join_predicate event added. See the full explanation below for the reasoning.
Question
You use Microsoft SQL Server Profile to evaluate a query named Query. 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?
Options
- AStart a SQL Server Profiler trace for the event class Auto Stats in the Performance event
- 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
- DCreate one Extended Events session with the sqlserver.missing_join_predicate event added.
How the community answered
(33 responses)- A9% (3)
- B3% (1)
- C6% (2)
- D82% (27)
Community Discussion
No community discussion yet for this question.