The Exam 70-229 is the Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition exam. To be able to take the exam you should have work experience in medium to large computing environment that utilizes the Microsoft SQL Server 2000 Enterprise Edition. You should also have minimum of one year work experience regarding implementation of relational databases. This includes heterogeneous databases, client and server configurations, SQL Server Security, web configurations utilizing Internet Information Services and COM+, installation of SQL Server 2000 and databases of up to 2 terabytes.

Credits You Earn for Passing Exam 70-229

You will achieve the Microsoft Certified Professional (MCP) status once you pass the Exam 70-229. Passing the test would also give you credits on several certifications such as Microsoft Certified Database Administrator on Microsoft SQL Server 2000, Microsoft Certified Systems Engineer on Microsoft Windows 2000, Microsoft Certified Systems Engineer on Microsoft Windows NT 4.0, Microsoft Certified Solution Developer for Microsoft .NET, Microsoft Certified Solution Developer and Microsoft Certified Application Developer for Microsoft .NET. People who have previous experience in handling Microsoft SQL Server 2005 should consider getting credentials including Microsoft Certified IT Professional (MCITP) and Microsoft Certified Technology Specialist (MCTS). These certifications specialize on simpler frameworks which are suitable for displaying on-the-job and technical skills.

Skills Targeted by the Exam 70-229

Before taking the Exam 70-229, you may ensure yourself to pass if you already have extensive knowledge in different topics involving Microsoft SQL Server 2000 Enterprise Edition. The abilities to be measured by the exam include skills in logical data model development. This section of the exam contains questions about defining and designing entity keys and attributes. It also covers creating designs for attribute domain integrity.

The exam also covers some topics implementation of physical databases, retrieval and modification of data and creating business logic programs. This portion of the test is about development and modification of database objects as well as troubleshooting of failed object creation.

The test also determines the candidate’s knowledge in optimizing and tuning data access as well as creating designs for database security plans.

Helpful Preparations for Exam 70-229

All of these topics are available for review in the required classroom training course 2071 which is the Querying Microsoft SQL Server 2000 with Transact-SQL. The Course 2073 or Programming a Microsoft SQL Server 2000 Database course is also recommended for those who are preparing for Exam 70-229.