Microsoft
70-457 · Question #88
70-457 Question #88: Real Exam Question with Answer & Explanation
Sign in or unlock 70-457 to reveal the answer and full explanation for question #88. The question stem and answer options stay visible for context.
Question
You are developing a database application by using Microsoft SQL Server 2012. You have a query that runs slower than expected. You need to capture execution plans that will include detailed information on missing indexes recommended by the query optimizer. What should you do?
Options
- AAdd a HASH hint to the query.
- BAdd a LOOP hint to the query.
- CAdd a FORCESEEK hint to the query.
- DAdd an INCLUDE clause to the index.
- EAdd a FORCESCAN hint to the Attach query.
- FAdd a columnstore index to cover the query.
- GEnable the optimize for ad hoc workloads option.
- HCover the unique clustered index with a columnstore index.
- JInclude a SET STATISTICS PROFILE ON statement before you run the query.
Unlock 70-457 to see the answer
You've previewed enough free 70-457 questions. Unlock 70-457 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.