We are in the process of merging Microsoft Learning with Microsoft Learn, which will be complete by June 30, 2020. You’ll find all relevant training and certification information is now available on Microsoft Learn. For more information, refer to the FAQ.
In response to the coronavirus (COVID-19) situation, Microsoft is implementing several temporary changes to our training and certification program. Learn more.


SQL Server

  • Published:
    September 30, 2008
  • Languages:
  • Audiences:
    IT professionals
  • Technology:
    Microsoft SQL Server 2008
  • Credit toward certification:

Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

This exam has been retired

For currently available options, please see the Microsoft Certification exam list.

Skills measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Implementing an SSIS solution (15-20%)
  • Implement control flow
    • Checkpoints; debug control flow; transactions; implement the appropriate control flow task to solve a problem; data profiling and quality
  • Implement data flow
    • Debug data flow; implement the appropriate data flow components
  • Implement dynamic package behavior by using property expressions
  • Implement package logic by using variables
    • System variables; user variables; variable scope
  • Implement package configurations
  • Implement auditing, logging, and event handling
    • Use system variables for auditing; use event handlers; propagate events; use log providers; data profiling
  • Extend SSIS packages by using .NET code
    • Use the script task; use the script component; use custom assemblies

Preparation resources

Configuring, deploying, and maintaining SSIS (15-20%)
  • Install and maintain SSIS components
    • Implement disaster recovery for SSIS
  • Deploy an SSIS solution
    • Deploy SSIS packages by using DTUTIL; deploy SSIS packages by using the deployment utility; deploy SSIS packages to SQL or file system locations
  • Manage SSIS package execution
    • Schedule package execution by using SQL Server Agent; execute packages by using DTEXEC; execute packages by using SQL Server Management Studio; execute packages by using the SSIS .NET API
  • Configure SSIS security settings
    • MSDB database roles; package protection levels
  • Identify and resolve issues related to SSIS solution deployment
    • Validate deployed packages; deploy packages and dependencies between servers

Preparation resources

Implementing an SSAS solution (20-25%)
  • Implement dimensions in a cube
    • Translations; attribute relations; hierarchies
  • Implement measures in a cube
    • Measure groups
  • Implement a data source view
    • Named calculations; named queries
  • Configure dimension usage in a cube
    • Implement reference dimensions; implement many to many relationships; implement fact relationships; implement role-playing relationships; define granularity
  • Implement custom logic in a cube by using MDX
    • Actions; key performance indicators (KPI); calculated members; calculations
  • Implement data mining
    • Implement data mining structures and models; query data mining structures by using DMX; data mining views
  • Implement storage design in a cube
    • Aggregations; partitions; storage modes; proactive caching

Preparation resources

Configuring, deploying, and maintaining SSAS (15-20%)
  • Configure permissions and roles in SSAS
    • Server roles; SSAS database roles; cube roles; enable client application access; implement custom access to data
  • Deploy SSAS databases and objects
    • Deployment wizard; BIDS; SSMS; SSIS analysis services execute DDL task
  • Install and maintain an SSAS instance
    • Disaster recovery
  • Diagnose and resolve performance issues
    • Use SQL Profiler; performance monitor counters; DMVs; usage based optimization wizard Implement processing options
  • Implement processing options

Preparation resources

Implementing an SSRS solution (10-15%)
  • Implement report data sources and datasets
    • Query types; dynamic data sources; filter location (dataset vs. query)
  • Implement a report layout
    • Apply conditional formatting; page configuration; headers and footers
  • Extend an SSRS solution by using code
    • Custom .NET assembly; private code
  • Create an SSRS report by using an SSAS data source
    • MDX in an SSRS report; DMX in an SSRS report
  • Implement report parameters
    • Databound parameters; multi-value parameters
  • Implement interactivity in a report
    • Drilldown; drillthrough; interactive sorting
  • Implement report items
    • Matrix; table; chart; image; list; grouping
  • Embed SSRS reports in custom applications
    • Use the Windows forms report viewer; use the web forms report viewer; use the SSRS web service

Preparation resources

Configuring, deploying, and maintaining SSRS (13%)
  • Configure report execution and delivery
    • Subscriptions; report caching; schedules; snapshot history
  • Install and configure SSRS instances
    • Deploy an SSRS web farm
  • Configure authentication and authorization for a reporting solution
    • Configure server-level and item-level role-based security; configure Windows authentication and custom authentication
  • Deploy an SSRS solution
    • RS.exe scripts; report builder; BIDS
  • Configure SSRS availability
    • Key management; migrate SSRS databases

Preparation resources

Preparation options

Instructor-led training
Practice test

Take a Microsoft Official Practice Test for Exam 448


MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance
Published: April 15, 2009

Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Buy this book at the Microsoft Press Store

Who should take this exam?

Candidates for this exam are responsible for creating business intelligence (BI) solutions by using SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services.

This exam is intended for professionals who develop solutions by using the SQL Server 2008 BI tool suite. The qualified candidate for this exam typically has:

  • one to two years of experience working with the Microsoft .NET Framework
  • two to three years of experience using SQL Server 2005 BI components
  • six months to one year of experience using SQL Server 2008
  • experience using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
  • experience using Microsoft SQL Server Management Studio (SSMS)
  • knowledge of relational and multi-dimensional database schemas
  • experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
  • experience creating and deploying a data mining model in SSAS
  • experience writing relational and multi-dimensional database queries
  • experience creating and deploying SQL Server Reporting Services (SSRS) reports
  • experience authoring and deploying SQL Server Integration Services (SSIS) packages
  • experience debugging, monitoring, and troubleshooting BI solutions

More information about exams

Preparing for an exam

We recommend that you review this exam preparation guide in its entirety and familiarize yourself with the resources on this website before you schedule your exam. See the Microsoft Certification exam overview for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.


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. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources. These training resources do not necessarily cover all topics listed in the "Skills measured" section.