Quiz-summary
0 of 10 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
Information
Practice Questions
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Answered
- Review
-
Question 1 of 10
1. Question
CDC Control Task consists of 3 major components, one of which is the CDC Source. From the following options, choose the option that incorrectly defines a CDC Source.
Correct
The variable name holding CDC state is part of the CDC source configuration and not CDC Splitter.
Incorrect
The variable name holding CDC state is part of the CDC source configuration and not CDC Splitter.
-
Question 2 of 10
2. Question
When designing a CDC Source task and you are presented with 5 different processing options. From the following list, please select the option which is NOT part of the CDC Processing Mode.
Correct
All with merge does not exist, the correct alternative is All with old values which returns changes from the current CDC processing range along with the old values.
Incorrect
All with merge does not exist, the correct alternative is All with old values which returns changes from the current CDC processing range along with the old values.
-
Question 3 of 10
3. Question
A CDC Splitter is used to split the flow of change rows from a CDC source data flow into various paths. From the options below, which of these is NOT a path CDC source data flow is split into based on the column __$operation?
Correct
Add does not exist, the other 3 options are Update –> Before-update row, Update –> Merge row and Other = Error.
Incorrect
Add does not exist, the other 3 options are Update –> Before-update row, Update –> Merge row and Other = Error.
-
Question 4 of 10
4. Question
A company using SQL Data Warehouse designing requires you to split certain tables of data for ease of access. You are tasked with using CDC Splitter to meet their requirements. From the following list of options when the split is based on the column __$operation which of these statements is incorrect?
Correct
__$modify_Isn sounds similar to __$update_mask but it does not exist, a suitable option would have been __$end_Isn –> which is used for columns to reserve future enhancements.
Incorrect
__$modify_Isn sounds similar to __$update_mask but it does not exist, a suitable option would have been __$end_Isn –> which is used for columns to reserve future enhancements.
-
Question 5 of 10
5. Question
When running a package in debug mode, the progress can be visually monitored as the success or failure of all package tasks is displayed on icons at the top right. Which of the following options is incorrect when describing these icons?
Correct
There are only 3 icons, Green check, yellow spinner and a red circle with X, the “orange question mark ?” does not exist
Incorrect
There are only 3 icons, Green check, yellow spinner and a red circle with X, the “orange question mark ?” does not exist
-
Question 6 of 10
6. Question
Usually, when testing a package and troubleshooting for issues the details of an execution result can be found in the last tab of the package design environment. From the options below choose the statement which incorrectly describes the details found in the last tab.
Correct
The information displayed under both tabs is the same as the execution details are more in-depth and useful for debugging.
Incorrect
The information displayed under both tabs is the same as the execution details are more in-depth and useful for debugging.
-
Question 7 of 10
7. Question
When dealing with package execution reports in the management studio, you have the option to display “All Executions reports”, these display the statistical numbers for failed and successful tasks. Additional columns contain data regarding specific reports, from the following options, which of these statements is incorrect in relation to these columns.
Correct
When diagnostic logging is enabled, the “All messages” column can display pages of details.
Incorrect
When diagnostic logging is enabled, the “All messages” column can display pages of details.
-
Question 8 of 10
8. Question
Sometimes using execution metrics increases efficiency when gauging the package runtime to fit within a maintenance window. One such execution metric is the Performance metric. From the following options, select the statement which incorrectly describes the performance execution metric.
Correct
The SSIS is extremely memory intensive, as a lot of data is being copied across the enterprise, it is highly recommended to keep the network and database crew on call.
Incorrect
The SSIS is extremely memory intensive, as a lot of data is being copied across the enterprise, it is highly recommended to keep the network and database crew on call.
-
Question 9 of 10
9. Question
Organizations sometimes use parallelization to increase SSIS performance by orders of magnitude. From the following list, select the incorrect statement when describing parallelization.
Correct
Similar to loading dimension tables together, fact tables are also loaded in parallel however, depending on the size only a few are loaded together.
Incorrect
Similar to loading dimension tables together, fact tables are also loaded in parallel however, depending on the size only a few are loaded together.
-
Question 10 of 10
10. Question
In order to allow data to flow in and out of an SSIS package smoothly, the main task is achieved with the connection manager. The options below list out some common connection types for the connection manager, please select the incorrect one.
Correct
A word connection would not commonly be used for database designing, a suitable alternative would be an SSAS Connection –> MSOLAP100.
Incorrect
A word connection would not commonly be used for database designing, a suitable alternative would be an SSAS Connection –> MSOLAP100.