MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 200
Pages: 200
Authors: Thomas Moore
- 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
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 200
Pages: 200
Authors: Thomas Moore