Duties of a Microsoft Certified Professional (MCP), for which nearly every network out there requires at least one, include the installation, configuration and maintenance of PCs, networking equipment and network operating systems. As well, an MCP must deal with patching systems where necessary as well as locking down systems so that only authorized personal can access and use them. Microsoft network administration is a rather highly technical role. 

A good understanding of Microsoft Windows network operating systems, network equipment and networking protocols is essential, as well as a basic ability to program scripts and batch files. However, relatively strong interpersonal skills are also important, as the MCP must understand the networking needs and problems of users and be able to address those issues in a timely fashion. Lastly, an MCP must be diligent at documenting the network as well as be proficient at troubleshooting problems, often under tense situations. This includes knowing when to give up trying to be the hero when solving a problem and having the humility to go to outside sources for help.

Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition (Exam 70-228)

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.

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

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

·     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