SQL Server Integration Services (SSIS) Courseware (55321AC)

What is SQL Server Integration Services (SSIS) used for?

• Database administration
• Data integration and ETL
• Web application development
• Network security

Which component in SSIS is used to extract data from different sources?

• Data Flow Task
• Control Flow
• Execute SQL Task
• Script Task

Which control flow task in SSIS is used to execute a stored procedure?

• Execute Process Task
• Execute SQL Task
• Data Flow Task
• File System Task

What is the primary purpose of SSIS transformations?

• To store data in databases
• To move data between servers
• To modify and process data within a Data Flow
• To generate reports

Which SSIS component is used for handling errors in a Data Flow?

• Event Handlers
• Error Output
• Control Flow
• Expression Builder

Which SSIS data flow transformation is used to merge two datasets?

• Aggregate Transformation
• Merge Join Transformation
• Derived Column Transformation
• Conditional Split Transformation

What is the purpose of the SSIS Package Deployment Model?

• To move SSIS packages between environments
• To execute SQL scripts
• To create new databases
• To perform real-time analytics

Which SSIS container is used to repeat a task for a set number of times?

• Foreach Loop
• For Loop
• Sequence Container
• While Loop

What is the purpose of Checkpoints in SSIS?

• To restart a package from the point of failure
• To store logs for auditing
• To improve query performance
• To execute stored procedures

Which SSIS logging provider writes log entries to a SQL Server table?

• XML File Logging
• SQL Server Logging
• Text File Logging
• Windows Event Logging