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:
- 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.
- 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.
- 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.
- Back up databases.
- Restore databases.
- Manage and configure databases.
- Manage database snapshots.
- Maintain database integrity.
- Maintain a database by using maintenance plans.
- Import and export data.
- Manage data partitions.
- Implement data compression.
- Maintain indexes.
- Manage collations.
- Identify SQL Server service problems.
- Identify concurrency problems.
- Identify SQL Agent job execution problems.
- Locate error information.
- 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.
- Implement database mirroring.
- Implement a SQL Server clustered instance.
- Implement log shipping.
- Implement replication.
