Which type of index storage should you recommend?

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:

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:

Answer:



Leave a Reply 1

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