Question 10

Answer D is correct. In many situations, it is a good idea to disable indexes while performing data imports. To do so, you use the ALTER INDEX command. The DISABLE option turns the index off to allow for more immediate data imports. To enable the index, you need to rebuild it. In particular, clustered indexes require data reordering when importing has been completed. To enable indexes, you use the REBUILD option. Dropping and creating indexes would work, although it is unnecessary because the disable functionality is available.

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, Indexes, Implementing Indexes, Modifying Indexes, Disabling Indexes"

  • "Chapter 14 - Improving SQL Server Performance,"

  • Within MSDN Library, go to MSDN Home, MSDN Library, .NET Development, Improving .NET Application Performance and Scalability, Improving SQL Server Performance.

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 © 2008-2017.
If you may any questions please contact us: