Take this exam and get a free Second Shot to pass. Sign in to see if you are already eligible.


SQL Server

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

Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

* Secondary and higher education students are eligible for special academic pricing. See Exam policies and FAQ for details. Pricing does not reflect any promotional offers or reduced pricing for Microsoft IT Academy program members, Microsoft Certified Trainers and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

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 in the exam. The higher the percentage, the more questions you are likely to see on that content area in 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.

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 behaviour 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 optimisation 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 authorisation 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
Find a Microsoft Learning Partner near you
Practice test

Take a Microsoft Official Practice Test for Exam 448

From the community

Follow @MSLearning and @sqlserver


MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance
Published: 15 April 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 organisations. 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 familiarise 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 of the topics listed in the "Skills measured" section.