You need to recommend an index strategy to maximize per…

DRAG DROP
You have a server named SQL1 that has SQL Server 2014 installed. SQL1 hosts a database named Database!
Database1 contains a table named Table1. Table1 is partitioned across five filegroups based on the
TransactionType 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:

DRAG DROP
You have a server named SQL1 that has SQL Server 2014 installed. SQL1 hosts a database named Database!
Database1 contains a table named Table1. Table1 is partitioned across five filegroups based on the
TransactionType 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:

Answer:

Explanation:
Note:
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.
Partitioned Tables and Indexes



Leave a Reply 3

Your email address will not be published. Required fields are marked *