| Preparing for an ExamThis exam will be retired on June 30th, 2011. |
• See a complete list of exams scheduled for retirement.
• Read frequently asked questions about exam retirements.
| 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 CertificationExam 70-446: PRO: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2005: counts as credit toward the following certification(s): |
| Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format. |