MCTS: SQL Server 2005 Business Intelligence

The Microsoft Certified Technology Specialist (MCTS) certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI) implement and maintain business intelligence solutions. They have thorough knowledge of the Microsoft SQL Server 2005 Business Intelligence Development tool suite. They have knowledge of database schemas and of debugging, monitoring, and troubleshooting Business Intelligence solutions, and they know how to work with Microsoft .NET Framework. They can write database queries, use SQL Server Analysis Services (SSAS) data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages. Typically, Technology Specialists pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.

How to earn your MCTS: SQL Server 2005 Business Intelligence

MCTS candidates must pass one exam that focuses on the implementation and maintenance of SQL Server 2005.

Required exams for MCTS: SQL Server 2005 BI (one exam required)

• Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence—Implementation and Maintenance

Audience profile

This exam is intended for experts in implementing and maintaining solutions by using the Microsoft SQL Server 2005 Business Intelligence tool suite. The qualified candidate for this exam typically has the following experience or knowledge.

• Knowledge of database schemas, both relational and multidimensional
• Experience with and/or knowledge of implementing a cube in SQL Server Analysis Services (SSAS)
• Experience with and/or knowledge of SSAS data mining algorithms
• Experience creating and deploying SQL Server Reporting Services (SSRS) reports
• Experience authoring and deploying SQL Server Integration Services (SSIS) packages
• Experience working with the Microsoft .NET Framework

Credit toward certification

When you pass Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance, you complete the requirements for the following certification:

• MCTS: SQL Server 2005 Business Intelligence

Exam 70-445 is also credit toward the following certification:

• MCITP: Business Intelligence Developer

Skills being measured