Book (1 April 2009)Official MS page
Skills measured by Exam 70-448
Implementing an SSIS Solution (17 percent)
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
Configuring, Deploying, and Maintaining SSIS (15 percent)¶
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
Implementing an SSAS Solution (21 percent)
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
Configuring, Deploying, and Maintaining SSAS (17 percent)¶
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.
Implementing an SSRS Solution (17 percent)
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
Configuring, Deploying, and Maintaining SSRS (13 percent)¶
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