1.
Which of the following statements is incorrect in MS SSIS?
2.
In MS SSIS, if each task in a package is complete, which of the following events is used to insert a message into the log table?
3.
In MS SSIS, if an XML file is loaded into a database using a package, which of the following steps needs to be performed first?
4.
In MS SSIS, if the data is being transformed over a data pipeline from a source to a destination, which of the following errors occurs?
5.
In MS SSIS, which of the following transformations is used to unnormalize the data structure by converting columns into rows incase of building Data Warehouses?
6.
In MS SSIS, which of the following optimizations will you make while executing SQL statements within the Integration Services?
7.
In MS SSIS, the Script component is a part of __________________________ transformation.
8.
Which of the following transformations distributes buffer of incoming rows uniformly across the outputs on threads separately to improve the performance of MS SSIS packages running on the multi-core and multi-processor servers?
9.
In MS SSIS, which of the following about DSV is not correct?
10.
In MS SSIS, which of the following is based on object collection?