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.
Select and Place:
Only IX_DATE should be aligned. All other are Nonaligned.
Explanation on:
https://technet.microsoft.com/en-us/library/ms187526(v=sql.105).aspx
https://docs.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes