70-228

(70-228) SQL 2000 Admin

SYNOPSIS • MCDBA ^vs • MCSA 2003 ^vs • MCSE 2000 ^vs • MCSE 2003 ^vs

Microsoft’s exam 70-228, “Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition?is a core requirement for the MCDBA (Microsoft Certified Database Administrator) on SQL Server 2000 certification. It is designed for candidates who “operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition.?There is no specific prerequisite for this exam but Microsoft recommends that candidates have “at least one year of experience administering SQL Server.?

Exam 70-228 is also an elective for these other certifications: MCSE (Microsoft Certified Systems Engineer) on Windows 2000; MCSE (Microsoft Certified Systems Engineer) on Windows NT 4.0; and MCSA (Microsoft Certified Systems Administrator) on Windows 2000.

This exam is easy to moderate in difficulty and costs $125 USD. It may be taken from Pearson Vue or Thomson Prometric.

At one time this exam provided no pass score other than Pass/Fail, but this is subject to change. “Beginning with the release of the Microsoft Windows Server?2003–related exams, Microsoft will provide numerical scores on exams. By the end of September 2003, most exams will have the new score report format, which includes this numerical score... The new scale requires a minimum passing score of 700 on all exams. The maximum score on the exams will vary depending on the complexity of the skills being measured.?- Microsoft Exam and Testing Procedures FAQ

Note that Microsoft does not document the format of a particular exam: “Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented.?In the past, though, this exam was form-based multiple choice with around 50 questions.

The topics covered by this exam include:

• Installing and Configuring SQL Server 2000
• Creating SQL Server 2000 Databases
• Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
• Extracting and Transforming Data with SQL Server 2000
• Managing and Monitoring SQL Server 2000 Security
• Managing, Monitoring, and Troubleshooting SQL Server 2000

For more information:
http://www.microsoft.com/traincert/exams/70-228.asp