SQL Server Integration Services Assessment


SQL Server Integration Services Assessment

Skills Assessment

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.


What Am I Buying?
When you purchase an assessment with Talevation, you will receive a credit for our online assessment portal. To access your purchase, you must head to our Login page found in the top right corner. There, you may redeem your credit and generate a link which will be sent to the candidate of your choosing.

How does it work?
Total Questions 39
Question Types Multiple Choice
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
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
Package Logging
Invalid Event Hander