Chapter 12. Practice Exam 2

The actual certification exam has 40 questions. To best simulate the exam circumstances, you should try to complete the 40 questions in this practice exam in 90 minutes.

Chapter 13, “Answers to Practice Exam 2,” provides the answers to this practice exam. Each answer is accompanied by references to the applicable materials in SQL Server 2005 Books Online and on the Microsoft official websites.

Exam Questions


You are attempting to create an index on an existing view called SalesOverQuota, created in the SALES database. When the view was initially created, no preparation was done for indexing. You want to maintain the condition that was originally attached to the WHERE clause of the view. How do you implement the index? ...

Get MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.