Skills required for Microsoft test 70-228.

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

Skills required for Microsoft test 70-228.

Rating:

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

1. Know SQL Server configuration options including guidelines regarding instance and default installation, upgrading earlier versions of SQL Server, and Net-Library setup.


2. Guidelines regarding database configuration including transaction log, data file, and filegroup configuration with regard to physical drive configurations, and storage locations.


3. Creating and altering a database object, 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. Guidelines regarding backup and restoration of database, and performing disaster recovery.


6. Troubleshooting problems by using System Monitor and SQL Profiler.


7. Know how to perform integrity checks. Methods include configuring Database Maintenance Plan Wizard and using Database Consistency Checker (DBCC).


8. Guidelines regarding how to set up IIS virtual directories to support XML.


9. Guidelines regarding Mixed Mode authentication and Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure.


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


11. Guidelines for implementing security using roles, i.e., applications, databases, and server roles.


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

Rating: