Skills required for Microsoft test 70-431.

Skills required for Microsoft test 70-431.

Rating:

Microsoft has specified more than thirty objectives for the test 70-431, which are grouped under six topics. Following are the important areas in which an individual should have good knowledge before taking the test 70-431:

1. Configuring Mixed Mode authentication and Windows Authentication, including client connectivity, client operating system, and security infrastructure.
2. Creating and altering database objects, transaction logs, and filegroups with the consideration of a space management parameter, such as autoshrink, growth increment, initial size, and maximum size.
3. Creating filegroups and assigning tables to them.
4. Identifying and defining primary key, foreign key, and constraints.
5. Enforcing business rules by creating views, stored procedures, functions, and triggers.
6. Creating clustered and nonclustered indexes.
7. Implementing security by using various roles such as applications, databases, and server roles.
8. Performing database integrity checks.
9. Performing backups and restores of a database, and performing disaster recovery.
10. Troubleshooting issues by using System Monitor and SQL Server Profiler.
11. Creating message types, queues, contracts, and services.
12. Inserting, retrieving, transforming, and managing data by using SQL Server Integration Services (SSIS) and BULK INSERT.
13. Implementing HTTP endpoint, log shipping, database snapshots, and database mirroring.
14. Performing replication between two database servers.

Rating: