Exam 70-464 topic 1 question 108 discussion

Actual exam question from Microsoft's 70-464

Question #: 108
Topic #: 1

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 NONCLUSTERED INDEX IX1 on Schema1.Table1 (Column1)
B. CREATE NONCLUSTERED INDEX IX1 on Schema1.Table1 (Column1, Column2, Column3) INCLUDE (Column4)
C. CREATE NONCLUSTERED INDEX IX1 on schema1.Table1 (Column1) INCLUDE (Column4)
D. CREATE NONCLUSTERED INDEX IX1 on Schema1.Table1 (Column1) INCLUDE (Column4) WHERE Column2 <> Column3

Show Suggested Answer

Suggested Answer: C 🗳️

by CodeMaestro at July 2, 2020, 11:58 a.m.

Comments

Submit Cancel

CodeMaestro

Highly Voted 4 years, 11 months ago

answer should be B

upvoted 11 times

...

Luzix

Most Recent 4 years, 7 months ago

Equality_columns displays columns using equality predicates , e.g “Select * from employee where id = 2” Inequality_columns displays columns using inequality predicates e.g “Select * from employee where id > 2”

upvoted 2 times

...

Luzix

4 years, 7 months ago

CREATE NONCLUSTERED INDEX [INDEXNAME] ON [TABLENAME] ( [EQUALITYCOLUMNNAME], [INEQUALITYCOLUMNNAME] ) INCLUDE ( [INCLUDECOLUMN] );

upvoted 2 times

...

Luzix

4 years, 7 months ago

B, I think SO

upvoted 3 times

...