The following is a list of Microsoft Exam 70-431 objectives and the skills being measured...
Note: The percentages indicate the relative weight of each major topic area on the exam. (Therefore if the exam has a total of 55 questions then a major section with 16% may have 9 questions)
Installing and Configuring SQL Server 2005 (?? percent)
- Install SQL Server 2005.
- Configure SQL Server 2005 instances and databases.
- Configure SQL Server security.
- Configure linked servers by using SQL Server Management Studio (SSMS).
Implementing High Availability and Disaster Recovery (?? percent)
- Implement database mirroring.
- Implement log shipping.
- AdManage database snapshots.
Supporting Data Consumers (?? percent)
- DeRetrieve data to support ad hoc and recurring queries.
- Manipulate relational data.
- Manage XML data.
- Implement an HTTP endpoint.
- Implement Service Broker components.
- Import and export data from a file.
- Manage replication.
Maintaining Databases (?? percent)
- Implement and maintain SQL Server Agent jobs.
- Manage databases by using Transact-SQL.
- Back up a database.
- Back up a database.
- Restore a database.
- Move a database between servers.
Monitoring and Troubleshooting SQL Server Performance (?? percent)
- Gather performance and optimization data by using the SQL Server Profiler.
- Gather performance and optimization data by using the Database Engine Tuning Advisor.
- Monitor and resolve blocks and deadlocks.
- Diagnose and resolve database server errors.
- Monitor SQL Server Agent job history.
- Gather performance and optimization data by using DMVs.
Creating and Implementing Database Objects (?? percent)
- Implement a table.
- Implement a view.
- Implement triggers.
- Implement functions.
- Implement stored procedures.