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