SQL Server

  • Published:
    September 30, 2008
  • Languages:
    English, Japanese
  • Audiences:
    IT professionals
  • Technology:
    Microsoft SQL Server 2008
  • Credit toward certification:

Microsoft SQL Server 2008, Implementation and Maintenance

This exam has been retired

For currently available options, please see the Microsoft Certification exam list.

Skills 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. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Installing and configuring SQL Server 2008 (11%)
  • Install SQL Server 2008 and related services
    • File locations; default paths; service accounts
  • Configure SQL Server instances
    • sp_configure; Dynamic Management Views (DMVs)
  • Configure SQL Server services
    • Configuration manager; SQL browser
  • Configure additional SQL Server components
    • SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), replication; MDS
  • Implement database mail
    • Set up and configure
  • Configure full-text indexing
    • Enable/disable, index population

Preparation resources

Maintaining SQL Server instances (9%)
  • Manage SQL Server Agent jobs
    • Create and schedule jobs; notification of job execution; disable/enable jobs; change job step order; logging
  • Manage SQL Server Agent alerts
    • Performance condition alerts; SQL event alerts; Windows Management Instrumentation (WMI) alerts
  • Manage SQL Server Agent operators
    • Operator schedules; fail safe operator; add a new operator; notification methods
  • Implement the declarative management framework (DMF)
    • Create a policy; verify a policy; schedule a policy compliance check; enforce a policy; create a condition
  • Back up a SQL Server environment
    • Operating system-level concepts; SQL Server Utility; compression media families

Preparation resources

Managing SQL Server security (18%)
  • Manage logins and server roles
    • Create logins; disable/enable logins; security model (authentication mode); password policy enforcement; fixed server roles; alter logins; create credentials; certificate logins
  • Manage users and database roles
    • User mapping; user-defined roles; fixed roles; guest, public, dbo; creating and deleting user roles; application roles
  • Manage SQL Server instance permissions
    • Logon triggers; permissions versus fixed role membership; cross-database ownership chaining; impersonation; endpoint permissions
  • Manage database permissions
    • Impersonation; cross-database ownership chaining
  • Manage schema permissions and object permissions
    • Manage schema ownership; object rights
  • Audit SQL Server instances
    • Use DDL triggers and logon triggers; C2; common criteria; login failures; event notifications
  • Manage transparent data encryption (TDE)
    • Impact of transparent data encryption on backups; certificate management; symmetric keys
  • Configure surface area
    • sp_configure

Preparation resources

Maintaining a SQL Server database (17%)
  • Back up databases
    • Full backups; differential backups; transaction log; compressed backups; file and filegroup backups; verifying backup; TDE backups
  • Restore databases
    • Online restores; full restores; differential restores; transaction log; file and filegroup restores; verifying restore; tail of the transaction log; TDE restores
  • Manage and configure databases
    • Files, file groups, and related options; database options; recovery model; attach/detach data
  • Manage database snapshots
    • Create, drop, revert
  • Maintain database integrity
    • DBCC CHECKDB; suspect pages; page level restores
  • Maintain a database by using maintenance plans
    • Maintenance Plan Wizard; Maintenance Plan Designer

Preparation resources

Performing data management tasks (10%)
  • Import and export data
    • NOT: SSIS
  • Manage data partitions
    • Switching data from one partition to another; add a filegroup; alter a partition function; alter a partition scheme
    • NOT: designing partition tables/indexes
  • Implement data compression
    • Sparse columns; page/row; Unicode compression
  • Maintain indexes
    • Create spatial indexes; create partitioned indexes; clustered and non-clustered indexes; XML indexes; disable and enable indexes; filtered index on sparse columns; indexes with included columns; rebuilding/reorganizing indexes; online/offline; statistics on filtered indexes
    • NOT: designing new indexes
  • Manage collations
    • Column collation; database collation; instance collation

Preparation resources

Monitoring and troubleshooting SQL Server (14%)
  • Identify SQL Server service problems
    • DB Engine service; SQL Agent service; SQL Browser service
  • Identify concurrency problems
    • Blocks, locks, deadlocks, activity monitor; relevant Dynamic Management Views
  • Identify SQL Agent job execution problems
    • Proxy accounts; credentials; job history
  • Locate error information
    • Error log; agent log; job execution history; event logs

Preparation resources

Optimizing SQL Server performance (12%)
  • 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
  • Collect performance data by using System Monitor
  • Use Performance Studio

Preparation resources

Implementing high availability (9%)
  • Implement database mirroring
    • Monitoring, configuring, failover
  • Implement a SQL Server clustered instance
    • Monitoring, configuring, failover
  • Implement log shipping
    • Monitoring, configuring, failover
  • Implement replication
    • Monitoring, configuring

Preparation resources

Preparation options

Instructor-led training
Practice test

Take a Microsoft Official Practice Test for Exam 432


MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance
Published: February 18, 2009

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.

Buy this book at the Microsoft Press Store

Who should take this exam?

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 work in jobs in which database administration is their main area of responsibility or who work in environments in which databases are central to their primary 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
  • Developers who build applications that use SQL Server 2008
  • IT professionals who work with third-party applications that are built on SQL Server 2008

More information about exams

Preparing for an exam

We recommend that you review this exam preparation guide in its entirety and familiarize yourself with the resources on this website before you schedule your exam. See the Microsoft Certification exam overview for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.


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. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources. These training resources do not necessarily cover all topics listed in the "Skills measured" section.