(70-442) Designing and Optimizing Data Access

SYNOPSIS • MCITP Database Developer ^vs
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 have expert knowledge of following areas:

• Writing Transact-SQL queries
• Programming the database
• Troubleshooting programming objects (stored procedures, triggers, user-defined functions [UDFs], user-defined types [UDTs}, and queries)
• Performing database tuning and optimization
• Designing databases, at both the conceptial and logical levels
• Implementing databases at the physical level
• Designing and troubleshooting the data access layer of the application
• Gathering business requirements

Microsoft 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. There are 50 questions and the exam last 90 minutes. The cost of this exam is $125 USD. You can take the exam at any Prometric or Pearson VUE.

This certification exam measures your ability to design database solutions using SQL Server 2005. Skills measured by this exam include:

• Designing Efficient Access to a SQL Server Service
• Designing a Database Query Strategy
• Designing Error-Handling Routines
• Designing a Transaction Strategy
• Performance Tuning a Database and Database Application

For more information:
http://www.microsoft.com/Learning/exams/70-442.asp