Exam 70-448

Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

$150.00 USD*

Not in the United States?

Microsoft Certified Professional exams are provided by a third-party vendor. Register for an exam at Prometric's website.

Schedule now

* Pricing does not include any promotional offers or reduced pricing for Microsoft IT Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Price is subject to change without notice. Price does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.
SQL Server logo
  • Published: September 30, 2008
  • Languages: English, French, German, Japanese, Russian, Spanish, Portuguese (Brazil), Chinese (Simplified)
  • Audiences: IT professionals
  • Technology: Microsoft SQL Server 2008
  • Credit toward certification: MCSA

Convince your boss email

Copy the following content into an email message to your boss and update [the bracketed text] with the appropriate content.

Dear [your boss's name]:

I'd like to expand and prove my technical skills by earning a Microsoft Certification. My next step is taking Exam 70-448. The registration fee is $150.00 USD.

When I pass this certification, you'll have proof of my ability to work with Microsoft SQL Server 2008. Microsoft has training and online resources to help me prepare for the exam. I believe I'll be more effective and productive after achieving this valuable technical certification.

Let me know if you have any questions. In the meantime, you can find out more about this exam at http://www.microsoft.com/learning/en-us/exam-70-448.aspx. As you can see, the exam validates skills that are crucial to our team's success.

Thank you for your support,

[your name]

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.

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

  • 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

  • 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

  • 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

  • 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 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

  • 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 options

Find training near you

Buy a practice test for Exam 70-448 from:

Cover of 'MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance'

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

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 of the topics listed in the "Skills measured" section.