Microsoft
70-457 · Question #64
70-457 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 70-457 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Question
You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. Your investigation shows the root cause is a query against a read-only table that has a clustered index. The query returns the following six columns: - One column in its WHERE clause contained in a non-clustered index - Four additional columns - One COUNT (*) column based on a grouping of the four additional columns You need to optimize the statement. 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.