TS: Microsoft SQL Server 2008, Implementation and Maintenance

Exam 70-432:

• TS: Microsoft SQL Server 2008, Implementation and Maintenance

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

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).
• This objective may include but is not limited to: operating system-level concepts

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.