SQL Server Integration Services Assessment

  • $10.00

This SQL Server Integration Services assessment 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 assessment is appropriate for those knowledgeable in SQL Server Integration Services with more than a year of experience.

Number of questions 39
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Control Flow
Data Flow
Error Logging
Package Deployment
Package Management
Scripting & Custom Components
Variables & Configuration
Tasks tested Adding a Variable to a Package
Additional Control Flow Tasks
Backward Compatibility Task
Best Practices for Package Design
Connection Manager
Control Flow Tasks
Create a Package Deployment Utility
Custom Objects
Data Flow Transformation
Data Viewers
Deploy a Package to SQL Server
Deployment Challenges
Disconnected Mode
Error Outputs
Executing Packages
ForEach Loop Enumerator
HTML E-mail Message
Import CSV File to a SQL Table
Invalid Event Hander
Managing Packages with Dtutil
Moving Table Data
Package Logging
Precedence Constraints
Protection Level Property
Restrict Access
Roles-Based Security
Scheduling Packages
SQL Server Maintenance Plans
SSIS Containers
SSIS Scripting
Transactions Support in SSIS
Understanding Configuration
Understanding Variables
Variable Types
Workflow Tasks
Working with Error Outputs
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)