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


book cover
MCTS 70-431: Implementing and Maintaining Microsoft® SQL Server 2005
By Thomas Moore
...............................................
Publisher: Que
Pub Date: July 31, 2006
Print ISBN-10: 0-7897-3588-1
Print ISBN-13: 978-0-7897-3588-1
Pages: 456
 

Table of Contents  | Index
overview

The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The Exam Cram focuses on exactly what you need to know to get certified. This includes features like:

  • Complete coverage of all 70-431 exam objectives

  • Exam alerts, practice questions, notes, tips, sidebars, cautions, test-taking strategies, and time-saving tips

  • Access to MeasureUp practice questions and innovative testing software

  • The popular Cram Sheet tear card, giving you the key facts you should review before you enter the testing center

  • Insight from author Thomas Moore, a Microsoft Certified Trainer (MCT) and SQL Server expert who has helped hundreds of students earn their SQL Server certifications



book cover
MCTS 70-431: Implementing and Maintaining Microsoft® SQL Server 2005
By Thomas Moore
...............................................
Publisher: Que
Pub Date: July 31, 2006
Print ISBN-10: 0-7897-3588-1
Print ISBN-13: 978-0-7897-3588-1
Pages: 456
 

Table of Contents  | Index

   Copyright
   About the Author
   Acknowledgments
   We Want to Hear from You!
   Reader Services
       Introduction
      About the 70-431 Exam and Content Areas
      How to Prepare for the Exam
      What This Book Does
      What This Book Does Not Do
      About This Book
       Self Assessment
      SQL Server Implementation and Maintenance as an MCTS
        Chapter 1.  Installing and Configuring SQL Server 2005
      Installing and Configuring SQL Server 2005
      Exam Prep Questions
        Chapter 2.  Creating Database Objects
      Creating and Defining Databases
      Defining SQL Server Tables
      SQL Server Programmability Objects
      Exam Prep Questions
      Answers to Exam Prep Questions
        Chapter 3.  Implementing Database Objects
      Data Querying and Reporting
      Data Querying Using Full-Text Indexes
      Using System Tables and Views
      Changing What Is Already Stored
      Removing Unwanted Data
      Exam Prep Questions
      Answers to Exam Prep Questions
        Chapter 4.  Supporting the XML Framework
      Managing XML Data
      Other SQL Server XML Support
      Exam Prep Questions
      Answers to Exam Prep Questions
        Chapter 5.  Data Consumption and Throughput
      Importing and Exporting Data
      Implementing Service Broker
      Exam Prep Questions
      Answers to Exam Prep Questions
        Chapter 6.  Database Maintenance
      SQL Server 2005 Database Maintenance
      Performing Database Backups
      Restoring Data from a Backup
      Using Database Snapshots
      Automating Maintenance with Job Scheduling
      Exam Prep Questions
      Answers to Exam Prep Questions
        Chapter 7.  Monitoring SQL Server Performance
      SQL Server Management Studio
      Monitoring and Recording Performance
      Using Windows System Monitor
      Using SQL Server Profiler
      Exam Prep Questions
      Answers to Exam Prep Questions
        Chapter 8.  Troubleshooting and Optimizing SQL Server
      Data Analysis and Problem Diagnosis
      Tuning the Database Structure
      Server Configuration Maintenance
      Exam Prep Questions
      Answers to Exam Prep Questions
        Chapter 9.  Implementing High Availability
      High-Availability Solutions
      Using Replication
      Microsoft Analysis Services
      Exam Prep Questions
      Answers to Exam Prep Questions
        Chapter 10.  Practice Exam 1
      Exam Questions
        Chapter 11.  Answers to Practice Exam 1
      Question 1
      Question 2
      Question 3
      Question 4
      Question 5
      Question 6
      Question 7
      Question 8
      Question 9
      Question 10
      Question 11
      Question 12
      Question 13
      Question 14
      Question 15
      Question 16
      Question 17
      Question 18
      Question 19
      Question 20
      Question 21
      Question 22
      Question 23
      Question 24
      Question 25
      Question 26
      Question 27
      Question 28
      Question 29
      Question 30
      Question 31
      Question 32
      Question 33
      Question 34
      Question 35
      Question 36
      Question 37
      Question 38
      Question 39
      Question 40
        Chapter 12.  Practice Exam 2
      Exam Questions
        Chapter 13.  Answers to Practice Exam 2
      Question 1
      Question 2
      Question 3
      Question 4
      Question 5
      Question 6
      Question 7
      Question 8
      Question 9
      Question 10
      Question 11
      Question 12
      Question 13
      Question 14
      Question 15
      Question 16
      Question 17
      Question 18
      Question 19
      Question 20
      Question 21
      Question 22
      Question 23
      Question 24
      Question 25
      Question 26
      Question 27
      Question 28
      Question 29
      Question 30
      Question 31
      Question 32
      Question 33
      Question 34
      Question 35
      Question 36
      Question 37
      Question 38
      Question 39
      Question 40
        Appendix A.  Suggested Readings and Resources
      Chapter 1: Installing and Configuring SQL Server 2005
      Chapter 2: Creating Database Objects
      Chapter 3: Implementing Database Objects
      Chapter 4: Supporting the XML Framework
      Chapter 5: Data Consumption and Throughput
      Chapter 6: Database Maintenance
      Chapter 7: Monitoring SQL Server Performance
      Chapter 8: Troubleshooting and Optimizing SQL Server
      Chapter 9: Implementing High Availability
        Appendix B.  Accessing Your Free MeasureUp Practice Test
        Appendix C.  MeasureUp's Product Features
      Multiple Testing Modes
      Question Types
      Random Questions and Order of Answers
      Detailed Explanations of Correct and Incorrect Answers
      Attention to Exam Objectives
      Technical Support
   Glossary
   Index