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.

Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (Exam 70-229)

Audience Profile

Candidates for this exam work in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience implementing relational databases in environments with the following characteristics:

·     Heterogeneous databases.

·     SQL Server security integrated with Windows Authentication.

·     Client/server configurations of 50 to 5,000 or more users.

·     Web configurations that use Internet Information Services (IIS) or COM+.

·     Databases as large as 2 TB.

·     Multiple installations of SQL Server 2000.

Credit Toward Certification

When you pass the Designing and Implementing Databases with 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 Solution Developer for Microsoft .NET certification

·    Elective credit toward Microsoft Certified Solution Developer certification

·    Elective credit toward Microsoft Certified Application Developer for Microsoft .NET certification

Skills Being Measured

This certification exam measures your ability to design and implement database solutions by using Microsoft SQL Server 2000 Enterprise Edition. Before taking the exam, you should be proficient in the job skills listed in the following

·     Developing a Logical Data Model

·     Implementing the Physical Database

·     Retrieving and Modifying Data

·     Programming Business Logic

·     Tuning and Optimising Data Access

·     Designing a Database Security Plan