Get in-depth exam preparation for Exam 70-431, the core MCTS exam for the new Microsoft IT Professional certifications--as you build real-world job skills. Includes 300 test questions, reviews, case studies, code samples, an exam discount, and more. Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a core exam for the new Microsoft IT Professional certifications. This kit packs the tools and features that exam candidates want most--including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Focusing on SQL Server 2005, this official study guide covers topics such as installing and configuring SQL Server, implementing database mirroring, managing database snapshots, working with XML and flat files, managing replication, backing up and restoring a database, monitoring and troubleshooting, and creating and implementing database objects. Ace your exam preparation and ramp up quickly on SQL Server 2005 database administration by working at your own pace through the lessons, hands-on exercises, and practice tests. The flexible, best-of-class test engine on CD features 300 practice questions and pre-assessment and post-assessment capabilities. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters, and get detailed explanations for right and wrong answers--including pointers back to the book for further study. You also get a 180-dayevaluation version of SQL Server 2005 Enterprise Edition and a 15 percent exam discount voucher--making this kit an exceptional value and a great career investment. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers enhanced sca