SQL Server Integration Services Assessment

$16.00

SQL Server Integration Services Assessment

$16.00
description

This SQL Server Integration Services test focuses on the skills that are needed to use SSIS to build high-performance data integration solutions. The areas addressed by this assessment include control and data flow, error logging, package deployment and management, scripting and custom components, and variable configuration. This test is appropriate for those knowledgeable in SQL Server Integration Services with more than a year of experience.

 

Number of questions 39
Competencies tested Control Flow
Variables & Configuration
Package Management
Data Flow
Scripting & Custom Components
Package Deployment
Error Logging
Tasks tested SSIS Containers
Workflow Tasks
Precedence Constraints
SQL Server Maintenance Plans
Additional Control Flow Tasks
Control Flow Tasks
Backward Compatibility Task
Import CSV File to a SQL Table
Moving Table Data
Transactions Support in SSIS
Connections
Error Outputs
Understanding Variables
Adding a Variable to a Package
Understanding Configuration
Variable Types
Create a Package Deployment Utility
Restrict Access
Roles-Based Security
Executing Packages
Managing Packages with Dtutil
Scheduling Packages
Working with Error Outputs
Data Flow Transformation
Connection Manager
Data Viewers
Best Practices for Package Design
HTML E-mail Message
ForEach Loop Enumerator
SSIS Scripting
Custom Objects
Disconnected Mode
Deployment Challenges
Deploy a Package to SQL Server
Protection Level Property
Checkpoints
Package Logging
Invalid Event Hander