Microsoft test 70-431 focuses on your ability to maintain and implement SQL Server 2005 computers. To successfully pass the test 70-431, you need to practice the following:
- Install and uninstall SQL Server 2005.
- Upgrade earlier versions of SQL Server.
- Configure SQL Server 2005 security.
- Create a trigger, identify recursive triggers, nested triggers, and transaction triggers.
- Create a function and identify deterministic and nondeterministic functions.
- Create and recompile stored procedures, and assign permissions to a role for a stored procedure.
- Create indexes.
- Configure linked servers by using SQL Server Management Studio.
- Implement and prepare databases for database mirroring.
- Execute ad hoc queries for retrieving data from a database.
- Execute Data Manipulation Language statements such as Insert, Update, and Delete.
- Manage and create database snapshots.
- Retrieve and modify XML data and create XML indexes.
- Implement Service Broker and create message types, queues, contracts, and services.
- Monitor and resolve blocks and deadlocks and identify the cause of a block.
Implement and configure log shippings.