PrepAway - Latest Free Exam Questions & Answers

Which type of index should you create for each table?

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.Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

One Comment on “Which type of index should you create for each table?


Leave a Reply