Question 1

Answer B is correct. The presence of a condition should not affect the addition of an index to the view. You must ensure that the WITH SCHEMABINDING option is performed when creating the view if you are going to be applying indexes. Because this preparatory step had not been completed, it needs to be done. WITH CHECK applies only to data modified through the view and ensures that when a row is modified through a view, the data remains visible through the view after the modification is committed. DROP EXISTING does not apply because there was no previously created index. Clustered or nonclustered applies to the physical properties of the index and is irrelevant in this case.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Designing and Creating Databases, Views (Database Engine), Designing and Implementing Views, Creating Indexed Views"

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: