Skills required for Microsoft test 70-229.

Skills required for Microsoft test 70-229.

Rating:

Microsoft has specified more than twenty-five objectives for the 70-229 test, which are grouped under seven topics. Following are the important areas in which an individual should possess good knowledge before taking the 70-229 test:

1. Logical and physical database designing considerations and normalization rules.


2. Identifying and defining primary key, foreign key, and unique constraints.


3. Creating and altering a database, transaction log, and file group with the consideration of a space management parameter, such as autoshrink, growth increment, initial size, and maximum size.


4. Inserting, retrieving, transforming, and managing data, using DTS and bulk insert.


5. Troubleshooting problems by using profiler and trace.


6. Guidelines regarding the placement of a file group and a transaction log file.


7. Guidelines regarding the creation of clustered and nonclustered indexes.


8. Guidelines regarding replication setup between two databases.


9. Guidelines regarding enforcing business rules by creating views, stored procedures, functions, and triggers.


10. Guidelines for implementing security, using the grant, deny, and revoke permissions.

Rating: