The Microsoft has defined different objectives for the 70-228 tests, which are re-grouped under different six subjects. The basic requirement of 70-228 test is as listed below:
1. You must know the SQL Server configuration and upgradation of older versions of SQL Server also have ability to setup Net-Library.
2. You also know the database configuration that involves data file, log, and filegroup configurations and storage positions.
3. You also know the change and create database, log, and file group looking to the space management aims.
4. You should have basic knowledge of retrieving, transforming, entering and managing data through DTS.
5. You must aware ablut the database recovery and backup.
6. You must solve the problems by applying the System Monitor and SQL Profiler.
7. You must have knowledge of security issues related to databases, server and applications.