InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
  Windows Essentials  
  SQL Server Administration  
  Windows Server 2003  
  .NET Application Development  
  Office Power User  
  Office Specialist  









































































Preparation Guide for Exam 70-228
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition


This preparation guide includes information about:

Audience Profile

Candidates for this exam operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience administering SQL Server. They also have at least one year of experience implementing relational databases in environments that contain:

  • Heterogeneous databases.
  • SQL Server security integrated with Windows Authentication.
  • Client/server configurations of 50 to 5,000 or more users.
  • Web configurations that use Microsoft Internet Information Services (IIS) or COM+.
  • Databases as large as two terabytes.
  • Multiple installations of SQL Server 2000.

To top of page

Credit Toward Certification

When you pass the Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition exam, you achieve Microsoft Certified Professional status. You also earn credit toward the following certifications:

  • Core credit toward Microsoft Certified Database Administrator on Microsoft SQL Server 2000 certification
  • Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows 2000 certification
  • Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows NT 4.0 certification
  • Elective credit toward Microsoft Certified Systems Administrator on Microsoft Windows 2000 certification

To top of page

Preparation Tools and Resources

We make a wealth of preparation tools and resources available to you, including courses, books, practice tests, and Microsoft Web sites. When you are ready to prepare for this exam, here's where you should start.

Instructor-led Courses for This Exam
  • ( Prerequisite ) Course 2071 : Querying Microsoft SQL Server 2000 with Transact-SQL
  • Course 2072 : Administering a Microsoft SQL Server 2000 Database

Microsoft Press Self-Paced Training

Microsoft Certified Practice Tests

  • MeasureUp : Visit the MeasureUp Web site to take a practice test.
  • Self Test Software : Visit the Self Test Software Web site to take a practice test.

Microsoft Online Resources

  • TechNet : Designed for IT professionals, this site includes How-tos, best practices, downloads, technical chats, and much more.
  • MSDN : The Microsoft Developer Network (MSDN) is a reference for developers, featuring code samples, technical articles, newsgroups, chats, and more.
  • Training & Certification Newsgroups : A newsgroup exists for every Microsoft certification. By participating in the ongoing dialogue, you take advantage of a unique opportunity to exchange ideas with and ask questions of others, including more than 750 Microsoft Most Valuable Professionals (MVPs) worldwide.

To top of page

Skills Being Measured

This certification exam measures your ability to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition. Before taking the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows which courses may help you reach competency in the skills being tested in the exam.

Installing and Configuring SQL Server 2000
Install SQL Server 2000. Considerations include clustering, default collation, file locations, number of instances, and service accounts.
Upgrade to SQL Server 2000.
  • Perform a custom upgrade.
  • Upgrade to SQL Server 2000 from SQL Server 6.5.
  • Upgrade to SQL Server 2000 from SQL Server 7.0.
Create a linked server.
Configure SQL Mail and SQLAgentMail.
Configure network libraries.
Troubleshoot failed installations.
Creating SQL Server 2000 Databases
Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations.
Attach and detach databases.
Create and alter databases.
  • Add filegroups.
  • Configure filegroup usage.
  • Expand and shrink a database.
  • Set database options by using the ALTER DATABASE or CREATE DATABASE statements.
  • Size and place the transaction log.
Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views.
Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
Optimize database performance. Considerations include indexing, locking, and recompiling.
Optimize data storage.
  • Optimize files and filegroups.
  • Manage database fragmentation.
Modify the database schema.
Perform disaster recovery operations.
  • Perform backups.
  • Recover the system state and restore data.
  • Configure, maintain, and troubleshoot log shipping.
Perform integrity checks. Methods include configuring the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC).
Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.
Extracting and Transforming Data with SQL Server 2000
Set up IIS virtual directories to support XML.
Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries.
Develop and manage DTS packages.
Manage linked servers.
  • Manage OLE DB Providers.
  • Configure security mapping.
Convert data types.
Configure, maintain, and troubleshoot replication services.
Managing and Monitoring SQL Server 2000 Security
Configure mixed security modes or Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure.
Create and manage log ons.
Create and manage database users.
Create and manage security roles. Roles include application, database, and server.
  • Add and remove users from roles.
  • Create roles to manage database security.
Enforce and manage security by using stored procedures, triggers, views, and user-defined functions.
Set permissions in a database. Considerations include object permissions, object ownership, and statement permissions.
Manage security auditing. Methods include SQL Profiler and C2 auditing.
Managing, Monitoring, and Troubleshooting SQL Server 2000
Create, manage, and troubleshoot SQL Server Agent jobs.
Configure alerts and operators by using SQL Server Agent.
Optimize hardware resource usage. Resources include CPU, disk I/O, and memory.
  • Monitor hardware resource usage by using System Monitor.
  • Resolve system bottlenecks by using System Monitor.
Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.
  • Monitor SQL Server system activity by using traces.
  • Monitor SQL Server system activity by using System Monitor.


INFORMIT - Skill Development Center
Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
Fax. (022) 4231 168 - E-mail:

  Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
© 2006, InformIT Ganesa Pratama. All Right Reserved