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"




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net