1.
In MS SSIS, which of the following transformations is synchronous?
2.
In MS SSIS, which of the following transformations is asynchronous?
3.
In MS SSIS, the raw file is a part of the _______________________.
4.
In MS SSIS, which of the following is different from rest of the options in terms of the Aggregation transformation operation?
5.
In MS SSIS, the look up terms in the reference table and the count terms of the ___________________ transformation are extracted from text.
6.
In MS SSIS, which of the following transformations is used to create the less normalized version of a normalized table?
7.
In MS SSIS, which of the following is not a Change Data Capture (CDC) components?
8.
In MS SSIS, if the state of each Change Data Capture (CDC) group is set as 5, which of the following is true?
9.
In MS SSIS, which of the following tasks is used to create a package that can read the folders such as Path, File Type, and Filename and Retention Period from a table and then loop through each folder path and delete required files whose retention period is more than defined?
10.
In MS SSIS, the Logical OR and the Logical AND setting is an important configuration option of the _____________________.