The following is a list of Microsoft Exam 70-441 objectives and the skills being measured...
Note: The percentages indicate the relative weight of each major topic area on the exam. (Therefore if the exam has a total of 55 questions then a major section with 16% may have 9 questions)
Designing Database Testing and Code Management Procedures (?? percent)
- Design a unit test plan for a database.
- Create a performance baseline and benchmarking strategy for a database.
- Create a plan for deploying a database.
- Control changes to source code.
Designing an Application Solution for SQL Server 2005 (?? percent)
- Select and design SQL Server services to support business needs.
- Design a logical database.
- Design an application solution to support security.
- Design an application solution that uses appropriate database technologies and techniques.
- Design an application solution that supports reporting.
- Design data distribution.
Designing Database Objects (?? percent)
- Design objects that define data.
- Design objects that retrieve data.
- Design objects that extend the functionality of a server.
- Design objects that perform actions.
Designing a Database (?? percent)
- Design attributes.
- Design entities.
- Design entity relationships (ER).
- Design database security.
- Automate installation of the 2007 Microsoft Office system.
- Customize and maintain Windows PE by using BDD Workbench.
Developing Applications That Use SQL Server Support Services (?? percent)
- Develop applications that use Reporting Services.
- Develop applications for Notification Services.
- Develop packages for Integration Services.