1.An SSIS package
container that is used to perform iterative processes.
(1 Point)
Task Containers
Sequence Containers
For Loop Containers
Foreach Loop
Containers
2.Using a sequence
container, you can ___________________________________________________
(1 Point)
Manage properties for
a single task
Manage properties for
multiple tasks
None of the above.
3.__________ variables
store information about the running package and its objects
(1 Point)
Dynamic variables
User Variables
Constants
System Variables
4.The ability to run
multiple control flows in parallel is a result of the SSIS's ability to use
__________ packages
(1 Point)
Multiple
Single
Deleted
New
1.When developing an
application you must use ______________ techniques to find the cause of the
problems and formulate a solution.
(1 Point)
Logging
Signing
Debugging
Delivering
2.Which of the
following is a technique that can be used for debugging during development?
(1 Point)
Observe row counts and
task outcomes.
Step through package
execution using breakpoints
View variable values
All of the above
3._____________________
can be used to pause execution at the stage where errors occur.
(1 Point)
Running Points
Breakpoints
Pausing
None of the above
4.The SSIS log
____________________ defines the specific details that can be logged for each
event.
(1 Point)
Schema
File
Document
Model
1.No matter how much
debugging you do, exceptions that cause errors can occur in any ETL process.
(1 Point)
True
False
¯\_(ツ)_/¯
Get Free Quote!
273 Experts Online