DRAG DROP
You use the following statement to create a table.
You have the following queries.
You need to create an index to minimize the execution time of the queries.
How should you complete the statement? To answer, drag the appropriate code elements to the correct
locations. Each code element may be used once, more than once, or not at all. You may need to drag the split
bar between panes or scroll to view content.
Select and Place:
Answer: 
Explanation:
Box 1: LastName
Redesign nonclustered indexes with a large index key size so that only columns used for searching and
lookups are key columns. Make all other columns that cover the query into nonkey columns. In this way, you
will have all columns needed to cover the query, but the index key itself is small and efficient.
Box 2: FirstName
Box 3: DepartmentID
Non-key columns, called included columns, can be added to the leaf level of a nonclustered index to improve
query performance by covering the query. That is, all columns referenced in the query are included in the index
as either key or non-key columns. This allows the query optimizer to locate all the required information from an
index scan; the table or clustered index data is not accessed.
Box 4: OfficeID