MCTS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Si quieres obtener la certificación de Microsoft de Microsoft SQL Server 2008, Business Intelligence Development and Maintenance tienes que superar el examen 70-448.

El examen 70-448 incluye el contenido de estos cursos:

6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Este es contenido del examen 70-448 :

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.
This objective may include but is not limited to: checkpoints; debug control flow; transactions; implement the appropriate control flow task to solve a problem; data profiling and quality
Implement data flow.
This objective may include but is not limited to: debug data flow; implement the appropriate data flow components
Implement dynamic package behavior by using property expressions.
Implement package logic by using variables.
This objective may include but is not limited to: system variables; user variables; variable scope
Implement package configurations.
Implement auditing, logging, and event handling.
This objective may include but is not limited to: use system variables for auditing; use event handlers; propagate events; use log providers; data profiling
Extend SSIS packages by using .NET code.
This objective may include but is not limited to: use the script task; use the script component; use custom assemblies
Configuring, Deploying, and Maintaining SSIS (15 percent)
Install and maintain SSIS components.
This objective may include but is not limited to: implement disaster recovery for SSIS
Deploy an SSIS solution.
This objective may include but is not limited to: 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.
This objective may include but is not limited to: 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.
This objective may include but is not limited to: MSDB database roles; package protection levels
Identify and resolve issues related to SSIS solution deployment.
This objective may include but is not limited to: validate deployed packages; deploy packages and dependencies between servers
Implementing an SSAS Solution (21 percent)
Implement dimensions in a cube.
This objective may include but is not limited to: translations; attribute relations; hierarchies
Implement measures in a cube.
This objective may include but is not limited to: measure groups
Implement a data source view.
This objective may include but is not limited to: named calculations; named queries
Configure dimension usage in a cube.
This objective may include but is not limited to: 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.
This objective may include but is not limited to: actions; key performance indicators (KPI); calculated members; calculations
Implement data mining.
This objective may include but is not limited to: implement data mining structures and models; query data mining structures by using DMX; data mining views
Implement storage design in a cube.
This objective may include but is not limited to: aggregations; partitions; storage modes; proactive caching
Configuring, Deploying, and Maintaining SSAS (17 percent)
Configure permissions and roles in SSAS.
This objective may include but is not limited to: server roles; SSAS database roles; cube roles; enable client application access; implement custom access to data
Deploy SSAS databases and objects.
This objective may include but is not limited to: Deployment Wizard; BIDS; SSMS; SSIS Analysis Services Execute DDL task
Install and maintain an SSAS instance.
This objective may include but is not limited to: disaster recovery
Diagnose and resolve performance issues.
This objective may include but is not limited to: 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.
This objective may include but is not limited to: query types; dynamic data sources; filter location (dataset vs. query)
Implement a report layout.
This objective may include but is not limited to: apply conditional formatting; page configuration; headers and footers
Extend an SSRS solution by using code.
This objective may include but is not limited to: custom .NET assembly; private code
Create an SSRS report by using an SSAS data source.
This objective may include but is not limited to: MDX in an SSRS report; DMX in an SSRS report
Implement report parameters.
This objective may include but is not limited to: databound parameters; multi-value parameters
Implement interactivity in a report.
This objective may include but is not limited to: drilldown; drillthrough; interactive sorting
Implement report items.
This objective may include but is not limited to: matrix; table; chart; image; list; grouping
Embed SSRS reports in custom applications.
This objective may include but is not limited to: 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.
This objective may include but is not limited to: subscriptions; report caching; schedules; snapshot history
Install and configure SSRS instances.
This objective may include but is not limited to: deploy an SSRS Web farm
Configure authentication and authorization for a reporting solution.
This objective may include but is not limited to: configure server-level and item-level role-based security; configure Windows authentication and custom authentication
Deploy an SSRS solution.
This objective may include but is not limited to: RS.exe scripts; Report Builder; BIDS
Configure SSRS availability.
This objective may include but is not limited to: key management; migrate SSRS databases

Puedes encontrar más información en la web de Microsoft

Tags: 70-448, SQL Server