Exam 70-461 topic 1 question 66 discussion

Actual exam question from Microsoft's 70-461

Question #: 66
Topic #: 1

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?

A. Add a HASH hint to the query.
B. Add a LOOP hint to the query.
C. Add a FORCESEEK hint to the query.
D. Add an INCLUDE clause to the index.
E. Add a FORCESCAN hint to the Attach query.
F. Add a columnstore index to cover the query.
G. Enable the optimize for ad hoc workloads option.
H. Cover the unique clustered index with a columnstore index.
I. Include a SET FORCEPLAN ON statement before you run the query.
J. Include a SET STATISTICS PROFILE ON statement before you run the query. K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query. L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query. M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query. N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.

Show Suggested Answer

Suggested Answer: F 🗳️

by designsfactory at April 4, 2025, 11:09 a.m.

Comments

Submit Cancel

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

Exam 70-461 All Questions

View all questions & answers for the 70-461 exam

Exam 70-461 topic 1 question 66 discussion

Comments

SY0-701