Question 38

Answers C and D are correct. The creation of XML indexes requires a minimum of a primary XML index. In addition, if indexing is to use exacting XML XQueries, you need to create a secondary XML index based on the initial primary one. Creating other types of indexes is irrelevant to the question.

For more information, see the following sources:

  • Chapter 4, "Supporting the XML Framework"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Using XML in SQL Server, xml Data Type, Indexes on xml Data Type Columns"

  • "XML Indexes in SQL Server 2005,"

  • Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, XML Indexes in SQL Server 2005.

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