Question 36


Answer C is correct. Using a clustered index usually improves performance. Making two separate views is likely to make the situation worse and will definitely make it more difficult to produce the desired results. Using the CLR will rarely improve performance for data-centric activities. A stored procedure is unlikely to perform any better than the view.

For more information, see the following sources:

  • Chapter 8, "Troubleshooting and Optimizing SQL Server"

  • "Creating Indexed Views," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdtsql/dvtskcreatingindexedviews.asp

  • "Designing an Indexed View," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_06_6ptj.asp




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

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