Exam Topics
Skills Being Measured:
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. Installing and Configuring SQL Server 2008 (10 percent)
- Install SQL Server 2008 and related services.
- Configure SQL Server instances.
- Configure SQL Server services.
- Configure additional SQL Server components.
- Implement database mail.
- Configure full-text indexing.
Maintaining SQL Server Instances (13 percent)
- Manage SQL Server Agent jobs.
- Manage SQL Server Agent alerts.
- Manage SQL Server Agent operators.
- Implement the declarative management framework (DMF).
- Back up a SQL Server environment.
Managing SQL Server Security (15 percent)
- Manage logins and server roles.
- Manage users and database roles.
- Manage SQL Server instance permissions.
- Manage database permissions.
- Manage schema permissions and object permissions.
- Audit SQL Server instances.
- Manage transparent data encryption.
- Configure surface area.
Maintaining a SQL Server Database (16 percent)
- Back up databases.
- Restore databases.
- Manage and configure databases.
- Manage database snapshots.
- Maintain database integrity.
- Maintain a database by using maintenance plans.
Performing Data Management Tasks (14 percent)
- Import and export data.
- Manage data partitions.
- Implement data compression.
- Maintain indexes.
- Manage collations.
Monitoring and Troubleshooting SQL Server (13 percent)
- Identify SQL Server service problems.
- Identify concurrency problems.
- Identify SQL Agent job execution problems.
- Locate error information.
Optimizing SQL Server Performance (10 percent)
- Implement Resource Governor.
- Use the Database Engine Tuning Advisor.
- Collect trace data by using SQL Server Profiler.
- Collect performance data by using Dynamic Management Views (DMVs).
- Collect performance data by using System Monitor.
- Use Performance Studio.
Implementing High Availability (9 percent)
- Implement database mirroring.
- Implement a SQL Server clustered instance.
- Implement log shipping.
- Implement replication.
Preparation Tools and Resources:
To help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the "Skills Measured" tab. Classroom Training:
- 6158C: Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 Days)
- 01: Learning Plan for Microsoft SQL Server 2008 Implementation and Maintenance (Exam 70-432) (1 Forms)
- 6231A: Maintaining a Microsoft SQL Server 2008 Database (5 Days)
- 6232A: Implementing a Microsoft SQL Server 2008 Database (5 Days)
- 6317A: Upgrading Your SQL Server 2000 Database Administration (DBA) Skills to SQL Server 2008 DBA Skills (3 Days)
- 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (3 Days)
Microsoft E-Learning:
- 6369AE: Implementing and Maintaining Microsoft SQL Server 2008 (16 Hours)
- 2778CE: Querying and Modifying Data in Microsoft SQL Server 2008 with Transact-SQL (18 Hours)
Microsoft Press Books:
- Microsoft SQL Server 2008 Step by Step
- MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance
- Programming Microsoft SQL Server 2008
- Inside Microsoft SQL Server 2008: T-SQL Querying
- Microsoft SQL Server 2008 T-SQL Fundamentals
- Programming Microsoft SQL Server 2008
- Microsoft SQL Server 2008 Internals
Practice Tests:
- MeasureUp
- Self Test Software
Microsoft Online Resources:
- SQL Server 2008 Learning Portal: Find special offers and information on training and certification.
- SQL Server 2008 product information: Visit the SQL Server 2008 Web site for detailed product information.
- Microsoft Learning Community: Join newsgroups and visit community forums to connect with your peers for suggestions on training resources and advice on your certification path and studies.
- TechNet: Designed for IT professionals, this site includes how-to instructions, best practices, downloads, technical resources, newsgroups, and chats.
- MSDN: Designed for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, downloads, newsgroups, and chats
Exam Specifics
Audience Profile:
Candidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work in environments in which databases are central to their job roles.
These job roles include the following:
- IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
- IT professionals who manage systems that run SQL Server 2008
- IT professionals who work with third-party applications that are built on SQL Server 2008
- Developers who build applications that use SQL Server 2008
Credit Toward Certification:
When you pass Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance, you complete the requirements for the following certification(s):
- Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance
Note:
This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format
|