TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Exam 70-448:

• TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Audience Profile

Candidates for this exam are responsible for creating business intelligence (BI) solutions by using Microsoft 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. 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

Credit Toward Certification When you pass Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance, you complete the requirements for the following certification(s):

• Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance

Skills Being 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.

Implementing an SSIS Solution (17 percent)

• Implement control flow.
• Implement data flow.
• Implement dynamic package behavior by using property expressions.
• Implement package logic by using variables.
• Implement package configurations.
• Implement auditing, logging, and event handling.
• Extend SSIS packages by using .NET code.

Configuring, Deploying, and Maintaining SSIS (15 percent)

• Install and maintain SSIS components.
• Deploy an SSIS solution.
• Manage SSIS package execution.
• Configure SSIS security settings.
• Identify and resolve issues related to SSIS solution deployment.

Implementing an SSAS Solution (21 percent)

• Implement dimensions in a cube.
• Implement measures in a cube.
• Implement a data source view.
• Configure dimension usage in a cube.
• Implement custom logic in a cube by using MDX.
• Implement data mining.
• Implement storage design in a cube.

Configuring, Deploying, and Maintaining SSAS (17 percent)

• Configure permissions and roles in SSAS.
• Deploy SSAS databases and objects.
• Install and maintain an SSAS instance.
• Diagnose and resolve performance issues.
• Implement processing options.

Implementing an SSRS Solution (17 percent)

• Implement report data sources and datasets.
• Implement a report layout.
• Extend an SSRS solution by using code.
• Create an SSRS report by using an SSAS data source.
• Implement report parameters.
• Implement interactivity in a report.
• Implement report items.
• Embed SSRS reports in custom applications.

Configuring, Deploying, and Maintaining SSRS (13 percent)

• Configure report execution and delivery.
• Install and configure SSRS instances.
• Configure authentication and authorization for a reporting solution.
• Deploy an SSRS solution.
• Configure SSRS availability.