Exam news

Exam 70-442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 became available on April 28, 2006. This is a Microsoft Certified IT Professional (MCITP) certification exam.

Audience profile

Candidates for this exam are professional database developers who design and implement database solutions. They have three or more years dedicated to database work, which may include writing Transact-SQL queries, designing and implementing programming objects, optimizing databases, designing databases at both the conceptual and logical levels, and implementing databases at the physical level. The typical work environment is an enterprise or a medium-sized organization. Candidates should be experienced in using Microsoft SQL Server 2005.

Candidates for this exam should be an expert in the following areas:

• Writing Transact-SQL queries

• Programming databases

• Troubleshooting programming objects (stored procedures, triggers, user-defined functions (UDFs), user-defined types (UDTs), and queries)

• Performing database performance tuning and optimization

• Designing databases, at both the conceptual and logical levels

• Implementing databases at the physical level

• Designing and troubleshooting the data access layer of the application

• Gathering business requirements

Credit toward certification

When you pass Exam 70-442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005, you earn credit toward the following certifications:

• Microsoft Certified IT Professional: Database Developer