Тест №70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005

Продолжительность:
Языки теста: English
Online тест:
Кол-во вопросов:
Мин.проходной балл:

Темы: 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. Candidate for this exam should be an expert in 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