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.
You are attempting to create an index on an existing view called