PrepAway - Latest Free Exam Questions & Answers

Which code segment should you execute?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
CREATE NONCLUSTERED INDEX IX1 on Schema1.Table1 (Column1) INCLUDE (Column4) WHERE
Column2 <> Column3

B.
CREATE NONCLUSTERED INDEX IX1 on Schema1.Table1 (Column1)

C.
CREATE NONCLUSTERED INDEX IX1 on Schema1.Table1 (Column1, Column2, Column3) INCLUDE
(Column4)

D.
CREATE NONCLUSTERED INDEX IX1 on schema1.Table1 (Column1) INCLUDE (Column4)

One Comment on “Which code segment should you execute?


Leave a Reply