Microsoft Exam Questions

Which type of index should you create for each table?

DRAG DROP
Your network contains a SQL Server 2012 instance named SQL1. SQL1 contains a
database named DB1. DB1 contains three tables.
The tables are configured as shown in the following table.

You plan to create indexes for the tables.
You need to identify which type of index must be created for each table. The solution must
minimize the amount of time required to return information from the tables.
Which type of index should you create for each table? To answer, drag the appropriate index
type to the correct table in the answer area.

Answer: