Developing Microsoft SQL Server Databases — Question 51

You are evaluating the index design.
You need to recommend a change to Indexes.sql that minimizes the amount of time it takes for usp_SelectEmployessByName to execute.
Which line of code should you use to replace line 08 of Indexes.sql?

Answer options

• A. (EmployeeID) INCLUDE (LastName);
• B. (LastName) INCLUDE (FirstName);
• C. (LastName, EmployeeID);
• D. (FirstName, LastName);

Correct answer: A

Explanation

The correct answer is A because including EmployeeID along with LastName will optimize the query by allowing the database to retrieve all necessary data without additional lookups. Options B and C do not include EmployeeID, which is essential for the usp_SelectEmployessByName execution, while D does not utilize the INCLUDE clause for performance enhancement.