| Preparing for an Exam |
This exam will be retired on June 30, 2011.
| 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 following areas:
Writing Transact-SQL queries
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
May be involved in designing and troubleshooting the data access layer of the application
Gathering business requirements
| Credit Toward CertificationExam 70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005: counts as credit toward the following certification(s): |
| Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format. |