70-441

(70-441) Designing Database Solutions

SYNOPSIS • MCITP Database Developer ^vs
Candidates for this exam are Professional Database Developers responsible for designing and implementing database solutions. They have 3 or more years dedicated to database work, which may include writing transact SQL queries, designing and implement programming objects, doing database optimization, 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 the 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)
• Doing database performance tuning and optimization
• Designing databases, at both the conceptual and logical levels
• Implementing databases at the physical level
• May be involved in 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 by using SQL Server 2005. Skills measured by this exam include:

• Designing Database Testing and Code Management Procedures
• Designing an Application Solution for SQL Server 2005
• Designing Database Objects
• Designing a Database
• Developing Applications That Use SQL Server Support Services

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