---

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

ISBN: 0789735881
EAN: 2147483647

Year: 2006
Pages: 200

Authors: Thomas Moore

BUY ON AMAZON

• MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005
• Table of Contents
• 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
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X