Preparation Guide for Exam 70-445TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance Exam news The Technology Specialist (TS) Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance was released in March 2007. Exam topics covered The following list includes the topic areas covered on this exam. The percentage indicates the portion of the exam that addresses a particular skill. • | Managing SSAS (12 percent) | • | Developing SSAS Solutions by Using BIDS (18 percent) | • | Implementing data mining by Using BIDs (12 percent) | • | Managing SSRS (13 percent) | • | Developing Reporting Solutions by Using SSRS (19 percent) | • | Developing Business Intelligence Solutions by Using SSIS (16 percent) | • | Administering SSIS Packages (11 percent) |
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 this exam, you earn credit toward the following certifications: MCTS: SQL Server 2005 Business Intelligence Preparation tools and resources We make a wealth of preparation tools and resources available to you, including courses, books, practice tests, and Microsoft Web sites. When you are ready to prepare for this exam, here's where you should start. Classroom training for this exam • | Course 2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services | • | Course 2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services | • | Course 2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services |
Microsoft Press self-paced training products • | Microsoft SQL Server 2005 Reporting Services Step by Step | • | Microsoft SQL Server 2005 Analysis Services Step by Step |
Microsoft certified practice tests • | MeasureUp: Visit the MeasureUp Web site to take a practice test. | • | Self Test Software: Visit the Self Test Software Web site to take a practice test. |
Microsoft online resources • | MSDN: The Microsoft Developer Network (MSDN) is a reference for developers that features code samples, technical articles, newsgroups, chats, and more. | • | Training and certification newsgroups: A newsgroup exists for every Microsoft certification. By participating in the ongoing dialogue, you take advantage of a unique opportunity to exchange ideas with and ask questions of others, including more than 750 Microsoft Most Valuable Professionals (MVPs) worldwide. |
Skills being measured This certification exam measures your ability to build business intelligence applications using Microsoft SQL Server 2005 business intelligence tools.
|
