Question 32

Answers A and B are correct. By partitioning and indexing on the data, you segregate the data efficiently and more easily present the information for reporting. A value() index is for use with XML data and serves no purpose in this scenario.

For more information, see the following sources:

• Chapter 3, "Implementing Database Objects"

• SQL Server 2005 Books Online: "SQL Server Database Engine, Designing and Creating Databases, Partitioned Tables and Indexes, Designing Partitioned Tables and Indexes, Special Guidelines for Partitioned Indexes"