Exam 70-432

Microsoft SQL Server 2008, Implementation and Maintenance

$150.00 USD*

Not in the United States?

Microsoft Certified Professional exams are provided by a third-party vendor. Register for an exam at Prometric's website.

Schedule now

* Pricing does not include any promotional offers or reduced pricing for Microsoft IT Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Price is subject to change without notice. Price does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.
SQL Server logo
  • Published: September 30, 2008
  • Languages: English, French, German, Japanese, Russian, Spanish, Portuguese (Brazil), Chinese (Simplified)
  • Audiences: IT professionals
  • Technology: Microsoft SQL Server 2008
  • Credit toward certification: MCSA

Convince your boss email

Copy the following content into an email message to your boss and update [the bracketed text] with the appropriate content.

Dear [your boss's name]:

I'd like to expand and prove my technical skills by earning a Microsoft Certification. My next step is taking Exam 70-432. The registration fee is $150.00 USD.

When I pass this certification, you'll have proof of my ability to work with Microsoft SQL Server 2008. Microsoft has training and online resources to help me prepare for the exam. I believe I'll be more effective and productive after achieving this valuable technical certification.

Let me know if you have any questions. In the meantime, you can find out more about this exam at http://www.microsoft.com/learning/en-us/exam-70-432.aspx. As you can see, the exam validates skills that are crucial to our team's success.

Thank you for your support,

[your name]

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.

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

  • 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

  • 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

  • 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

  • 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

  • Import and export data

    • BCP; BULK INSERT; OPENROWSET; GUI tools

    • 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

  • 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

  • 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

  • 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 options

Find training near you

Buy a practice test for Exam 70-432 from:

  • avatar image

    Does 70-342 already covers Exchange 2013 SP1 ?

    Posted by manolov.live.de on 01 Mar 2014 at 10:30 GMT

    Hi,


    As you know SP1 has been released for Exchange 2013 before couple of days. Does 70-342 already covers Exchange 2013 SP1 ? And where can I find official info about this ? (on the MS exam`s page it is not mentioned)


    Thanks :)

See more posts on Born To Learn

Cover of 'MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance'

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

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 of the topics listed in the "Skills measured" section.