Preparation Guide for Exam 70-446PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005 Exam news The professional (PRO) Exam 70-446: PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005 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. • | Planning BI Solutions (15 percent) | • | Designing SSIS Solutions (21 percent) | • | Designing SSRS Solutions (14 percent) | • | Designing SSAS Solutions (22 percent) | • | Deploying and Optimizing SSAS Solutions (15 percent) | • | Designing Data Mining Solutions (13 percent) |
Audience profile This exam is intended for IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2005 tools. The qualified candidate for this exam typically has the following experience. • | Experience working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) | • | At least one year of experience designing both relational and multidimensional database schemas | • | Experience designing and building cubes to support business requirements | • | One to two years of experience writing both relational and multidimensional queries | • | Experience in applying data mining algorithms to business problem domains | • | Experience designing and creating reports to support business requirements | • | Experience aggregating data into a data warehouse from multiple sources in a heterogeneous data environment | • | Experience in designing enterprise-level solutions for very large multidimensional databases |
Credit toward certification When you pass this exam, you earn credit toward the following certifications: MCITP: Business Intelligence Developer. 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. Instructor-led courses for this exam • | Course 2794: Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 | • | Course 2795: Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services | • | Course 2796: Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services | • | Course 2797: Designing a Reporting Solution Architecture Using 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 design and create business intelligence applications using Microsoft SQL Server 2005 business intelligence tools.
|
