Implementing an SSIS Solution
- Implement control flow which 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 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 system variables and user variables
- Implement package configurations.
- Implement auditing, logging, and event handling.
- Extend SSIS packages by using .NET code.
Configuring, Deploying, and Maintaining SSIS
- Install and maintain SSIS components.
- Deploy an SSIS solution by using common utility
- Manage SSIS package execution.
- Configure SSIS security settings.
- Identify and resolve issues related to SSIS solution deployment.
Implementing an SSAS Solution
- 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
- 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
- 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
- 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.
