SQL Server 2014 Integration Services Assessment

  • $10.00


This SQL Server 2014 Integration Service assessment has been designed to verify the ability of a developer to effectively work in a SQL 2014 environment. Topics covered by this assessment include transforms, packages, core concepts, commands and variables, and data flow. This assessment is appropriate to administer to assessment takers that have entry level or more experience with SQL Server 2014 Integration Services experience.

Number of questions 36
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Commands and Variables
Core Concepts
Data Flow
Packages
Transforms
Tasks tested BreakPoint
Checkpoint Command
Checkpoints
Connecting Data Flow Tasks
Data Access Mode
DataViewer Utility
DelayValidation Property
DTUTIL
Event Handler
Flat File Manager
Incremental Load
Log Entry
Lookup Transformation
Lookup Transformation CACHE Option
Lookup Transformation Connection Type
MaxConcurrentExecutables Default Value
Merge Transformation
Multicast Transformation
Package Configuration
Package Security
Pass Property Values
Precedence Constraint
Pulling Oracle Data
Run64BitRuntime
Scope of Connections
Script and Data Flow Task
Slowly Changing Dimension
SQL Server Agent
SSIS Container
SSIS File Extension
SSIS Package Information Storage
SSIS Purpose
Synchronous Transformation
System Variable
Transaction Default Mode
Union All Transformation
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)

We Also Recommend