Microsoft
70-768 · Question #38
70-768 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 70-768 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
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.
Unlock 70-768 to see the answer
You've previewed enough free 70-768 questions. Unlock 70-768 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.