Things to practice 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.
Things to practice for Microsoft test 70-228.
Rating:
Microsoft test 70-228 focuses on your ability to set up and manage SQL Server 2000 solutions at a system level. To successfully pass the 70-228 test, you should practice the following:
- Install and uninstall SQL Server 2000.
- Install and upgrade earlier versions of SQL Server.
- Import and export data using the Bulk Insert task, the bulk copy program, and Data Transformation Services (DTS).
- Create a link server and run ad hoc queries using the OPENQUERY function.
- Set up and configure a replication server.
- Set up IIS virtual directories to support XML.
- Use SQL Profiler and capture, analyze, replay, and study traces.
- Use System Monitor to optimize hardware resource usage.
- Configure alerts and operators by using SQL Server Agent.
- Define object level security including database, tables, and column level permissions.
Rating:
Was this information helpful?
Other articles
- What is SQL Profiler?
- What is the Log Reader agent?
- What is double hop?
- How to troubleshoot if an alert does not fire?
- What is sp_lock stored procedure?