Which type of index storage should you recommend?

DRAG DROP

You have a server named SQL1 that has SQL Server 2012 installed. SQL1 hosts a database named Database1. Database1 contains a table named Table1. Table1 is partitioned across five filegroups based on the Date field.

The schema of Table1 is configured as shown in the following table.

Table1 contains the indexes shown in the following table.

You need to recommend an index strategy to maximize performance for the queries that consume the indexes available to Table1.

Which type of index storage should you recommend? To answer, drag the appropriate index storage type to the correct index in the answer area.

View Answer

Answer:

Explanation:

Index Storage Type

Designing a partitioned index independently (unaligned) of the base table can be useful in the following cases:

– The base table has not been partitioned.

– The index key is unique and it does not contain the partitioning column of the table.

– You want the base table to participate in collocated joins with more tables using different join columns.