O'Reilly logo

MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 by Thomas Moore

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

1.

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? ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required