EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-432—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Maximize your performance on the exam by learning to:
PRACTICE TESTS Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.
Your kit includes:
Dedication; Acknowledgements; Introduction; Using the CD and DVD; Microsoft Certified Professional Program; Technical Support; Evaluation Edition Software; Chapter 1: Installing and Configuring SQL Server 2008; 1.1 Before You Begin; 1.2 Lesson 1: Determining Hardware and Software Requirements; 1.3 Lesson 2: Selecting SQL Server Editions; 1.4 Lesson 3: Installing and Configuring SQL Server Instances; 1.5 Lesson 4: Configuring Database Mail; 1.6 Chapter Review; 1.7 Suggested Practices; 1.8 Take a Practice Test; Chapter 2: Database Configuration and Maintenance; 2.1 Before You Begin; 2.2 Lesson 1: Configuring Files and Filegroups; 2.3 Files and Filegroups; 2.4 Transaction Logs; 2.5 FILESTREAM data; 2.6 tempdb Database; 2.7 Lesson 2: Configuring Database Options; 2.8 Database Options; 2.9 Collation Sequences; 2.10 Lesson 3: Maintaining Database Integrity; 2.11 Database Integrity Checks; 2.12 Chapter Review; 2.13 Suggested Practices; 2.14 Take a Practice Test; Chapter 3: Tables; 3.1 Before You Begin; 3.2 Lesson 1: Creating Tables; 3.3 Lesson 2: Implementing Constraints; 3.4 Chapter Review; 3.5 Suggested Practices; 3.6 Take a Practice Test; Chapter 4: Designing SQL Server Indexes; 4.1 Before You Begin; 4.2 Lesson 1: Index Architecture; 4.3 Lesson 2: Designing Indexes; 4.4 Lesson 3: Maintaining Indexes; 4.5 Chapter Review; 4.6 Suggested Practices; 4.7 Take a Practice Test; Chapter 5: Full Text Indexing; 5.1 Before You Begin; 5.2 Lesson 1: Creating and Populating Full Text Indexes; 5.3 Lesson 2: Querying Full Text Data; 5.4 Lesson 3: Managing Full Text Indexes; 5.5 Chapter Review; 5.6 Suggested Practices; 5.7 Take a Practice Test; Chapter 6: Distributing and Partitioning Data; 6.1 Before You Begin; 6.2 Lesson 1: Creating a Partition Function; 6.3 Lesson 2: Creating a Partition Scheme; 6.4 Lesson 3: Creating Partitioned Tables and Indexes; 6.5 Lesson 4: Managing Partitions; 6.6 Chapter Review; 6.7 Suggested Practices; 6.8 Take a Practice Test; Chapter 7: Importing and Exporting Data; 7.1 Before You Begin; 7.2 Lesson 1: Importing and Exporting Data; 7.3 Bulk Copy Program; 7.4 The BULK INSERT command; 7.5 Chapter Review; 7.6 Suggested Practices; 7.7 Take a Practice Test; Chapter 8: Designing Policy Based Management; 8.1 Before You Begin; 8.2 Lesson 1: Designing Policies; 8.3 Facets; 8.4 Conditions; 8.5 Policy Targets; 8.6 Policies; 8.7 Policy Categories; 8.8 Policy Compliance; 8.9 Import and Export Policies; 8.10 Chapter Review; 8.11 Suggested Practices; 8.12 Take a Practice Test; Chapter 9: Backing up and Restoring a Database; 9.1 Before You Begin; 9.2 Lesson 1: Backing up Databases; 9.3 Backup Types; 9.4 Partial Backups; 9.5 Page Corruption; 9.6 Maintenance Plans; 9.7 Certificates and Master Keys; 9.8 Validating a Backup; 9.9 Lesson 2: Restoring Databases; 9.10 Transaction Log Internals; 9.11 Database Restores; 9.12 Lesson 3: Database Snapshots; 9.13 Creating a Database Snapshot; 9.14 Reverting Data Using a Database Snapshot; 9.15 Chapter Review; 9.16 Suggested Practices; 9.17 Take a Practice Test; Chapter 10: Automating SQL Server; 10.1 Before You Begin; 10.2 Lesson 1: Creating Jobs; 10.3 Job Schedules; 10.4 Job History; 10.5 Operators; 10.6 Lesson 2: Creating Alerts; 10.7 SQL Server Agent Alerts; 10.8 Chapter Review; 10.9 Suggested Practices; 10.10 Take a Practice Test; Chapter 11: Designing SQL Server Security; 11.1 Before You Begin; 11.2 Lesson 1: TCP Endpoints; 11.3 TCP Endpoints; 11.4 Lesson 2: Configuring the SQL Server Surface Area; 11.5 Lesson 3: Creating Principals; 11.6 Lesson 4: Managing Permissions; 11.7 Lesson 5: Auditing SQL Server Instances; 11.8 Lesson 6: Encrypting Data; 11.9 Chapter Review; 11.10 Suggested Practices; 11.11 Take a Practice Test; Chapter 12: Monitoring Microsoft SQL Server; 12.1 Before You Begin; 12.2 Lesson 1: Working with System Monitor; 12.3 System Monitor Overview; 12.4 Capturing Counter Logs; 12.5 Performance Counters; 12.6 Lesson 2: Working with the SQL Server Profiler; 12.7 Defining a Trace; 12.8 Specifying Trace Events; 12.9 Selecting Data Columns; 12.10 Applying Filters; 12.11 Managing Traces; 12.12 Correlating Performance and Monitoring Data; 12.13 Lesson 3: Diagnosing Database Failures; 12.14 SQL Server Logs; 12.15 Database Space Issues; 12.16 Lesson 4: Diagnosing Service Failures; 12.17 Finding Service Startup Failures; 12.18 Lesson 5: Diagnosing Hardware Failures; 12.19 Disk Drives; 12.20 Memory and Processors; 12.21 Lesson 6: Resolving Blocking and Deadlocking Issues; 12.22 Locks; 12.23 Transaction Isolation Levels; 12.24 Blocked Processes; 12.25 Deadlocks; 12.26 Chapter Review; 12.27 Suggested Practices; 12.28 Take a Practice Test; Chapter 13: Optimizing Performance; 13.1 Before You Begin; 1111113.2 Lesson 1: Using the Database Engine Tuning Advisor; 13.3 Database Engine Tuning Advisor; 13.4 Lesson 2: Working with Resource Governor; 13.5 Resource Governor; 13.6 Lesson 3: Using Dynamic Management Views and Functions; 13.7 DMV Categories; 13.8 Lesson 4: Working with the Performance Data Warehouse; 13.9 Performance Data Warehouse; 13.10 Chapter Review; 13.11 Suggested Practices; 13.12 Take a Practice Test; Chapter 14: Failover Clustering; 14.1 Before You Begin; 14.2 Lesson 1: Designing Windows Clustering; 14.3 Lesson 2: Designing SQL Server 2008 Failover Cluster Instances; 14.4 Chapter Review; 14.5 Suggested Practices; 14.6 Take a Practice Test; Chapter 15: Database Mirroring; 15.1 Before You Begin; 15.2 Lesson 1: Overview of Database Mirroring; 15.3 Lesson 2: Initializing Database Mirroring; 15.4 Lesson 3: Designing Failover and Failback Strategies; 15.5 Chapter Review; 15.6 Suggested Practices; 15.7 Take a Practice Test; Chapter 16: Log Shipping; 16.1 Before You Begin; 16.2 Lesson 1: Overview of Log Shipping; 16.3 Lesson 2: Initializing Log Shipping; 16.4 Lesson 3: Designing Failover and Failback Strategies; 16.5 Chapter Review; 16.6 Suggested Practices; 16.7 Take a Practice Test; Chapter 17: Replication; 17.1 Before You Begin; 17.2 Lesson 1: Overview of Replication; 17.3 Lesson 2: Transactional Replication; 17.4 Lesson 3: Merge Replication; 17.5 Chapter Review; 17.6 Suggested Practices; 17.7 Take a Practice Test; Glossary; Answers; Chapter 1: Lesson Review Answers; Chapter 1: Case Scenario Answer; Chapter 2: Lesson Review Answers; Chapter 2: Case Scenario Answer; Chapter 3: Lesson Review Answers; Chapter 3: Case Scenario Answer; Chapter 4: Lesson Review Answers; Chapter 4: Case Scenario Answer; Chapter 5: Lesson Review Answers; Chapter 5: Case Scenario Answer; Chapter 6: Lesson Review Answers; Chapter 6: Case Scenario Answers; Chapter 7: Lesson Review Answers; Chapter 7: Case Scenario Answers; Chapter 8: Lesson Review Answers; Chapter 8: Case Scenario Answers; Chapter 9: Lesson Review Answers; Chapter 9: Case Scenario Answers; Chapter 10: Lesson Review Answers; Chapter 10: Case Scenario Answers; Chapter 11: Lesson Review Answers; Chapter 11: Case Scenario Answers; Chapter 12: Lesson Review Answers; Chapter 12: Case Scenario Answers; Chapter 13: Lesson Review Answers; Chapter 13: Case Scenario Answers; Chapter 14: Lesson Review Answers; Chapter 14: Case Scenario Answers; Chapter 15: Lesson Review Answers; Chapter 15: Case Scenario Answers; Chapter 16: Lesson Review Answers; Chapter 16: Case Scenario Answers; Chapter 17: Lesson Review Answers; Chapter 17: Case Scenario Answers; System Requirements; Hardware Requirements; Software Requirements; About the Author; Exam 70-432: Microsoft SQL Server 2008—Implementation and Maintenance; Additional Resources for IT Professionals from Microsoft Press; Windows Server; Windows Client; SQL Server 2005; Exchange Server 2007; Scripting; Get Certified—SQL Server 2008; Also See;
Overview
EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-432—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is ...