Microsoft test 70-432 focuses on your ability to maintain and implement SQL Server 2008 computers. To successfully pass the test 70-432, you need to practice the following:

  1. Install SQL Server 2008 and related services.
  2. Configure SQL Server instances.
  3. Configure SQL Server services.
  4. Configure additional SQL Server components.
  5. Implement database mail.
  6. Configure full-text indexing.
  7. Manage SQL Server Agent jobs.
  8. Manage SQL Server Agent alerts.

  9. Manage SQL Server Agent operators.
  10. Implement the declarative management framework (DMF).
  11. Back up a SQL Server environment.
  12. Manage logins and server roles.
  13. Manage users and database roles.
  14. Manage SQL Server instance permissions.
  15. Manage database permissions.
  16. Manage schema permissions and object permissions.
  17. Audit SQL Server instances.
  18. Manage transparent data encryption.
  19. Configure surface area.
  20. Back up databases.
  21. Restore databases.
  22. Manage and configure databases.
  23. Manage database snapshots.
  24. Maintain database integrity.
  25. Maintain a database by using maintenance plans.
  26. Import and export data.
  27. Manage data partitions.
  28. Implement data compression.
  29. Maintain indexes.
  30. Manage collations.
  31. Identify SQL Server service problems.
  32. Identify concurrency problems.
  33. Identify SQL Agent job execution problems.
  34. Locate error information.
  35. Implement Resource Governor.
  36. Use the Database Engine Tuning Advisor.
  37. Collect trace data by using SQL Server Profiler.
  38. Collect performance data by using Dynamic Management Views (DMVs).
  39. Collect performance data by using System Monitor.
  40. Use Performance Studio.
  41. Implement database mirroring.
  42. Implement a SQL Server clustered instance.
  43. Implement log shipping.
  44. Implement replication.