You review a query that runs slowly. The query accesses data in a table named
Schema1.Table1.
The following is the relevant portion of the execution plan for the query:
You need to create the missing index.
Which code segment should you execute?
A.
CREATE NONCLUSTEREDINDEX 1X1 on Schema1-
Table1(Column1)INCLUDE(Column4) WHERE Cclumn2 <> Column3
B.
CREATE NONCLUSTEREDINDEX 1X1 on Schema1.Table1(Column1)
C.
CREATE NONCLUSTEREDINDEX 1X1 on Schema1.Table1(Column1,Column2,
Column3) INCLUDE(Column1)
D.
CREATE NONCLUSTEREDINDEX 1X1 on
chema1.Table1(Column1)INCLUDE(Column4)
ANSWER C:
CREATE NONCLUSTERED INDEX 1X1 on Schema1.Table1 (Column1, Column2, Column3)
INCLUDE(Column4)
agree with your ans
Correct C
C.
source:
https://technet.microsoft.com/en-us/library/ms345405(v=sql.105).aspx
D is correct.
C is incorrect. Column1 is the equality column. It already appears in the indexed columns. You do not need to include it.
Agreed, but if C contains a typo and the include is actually for Column4 (which seems likely), then C would be correct.
2017 New 70-464 Exam Questions and Answers PDF are collected here: https://drive.google.com/folderview?id=0B9YP8B9sF_gNeUZnbHVMWDhuQzA&usp=sharing
I passed the exam already and those practice questions are my preparation materials, I have already uploaded there, you can have a look at them.