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
When connecting a database to an OLE DB Connection manager certain specifications must be made for the server and database details. From the following options choose the incorrect option with regards to common selections for database details.
Correct
The correct option is Enter Database Name –> The database name that will be connected to is chosen from the drop-down menu.
Incorrect
The correct option is Enter Database Name –> The database name that will be connected to is chosen from the drop-down menu.
-
Question 2 of 10
2. Question
A simple method used to troubleshoot data is by using Data Viewers. These display data flow in real-time, which can be validated or troubleshoot. While this Data Viewer window is open and the package is paused, you are presented with 3 options, from the following list, select the incorrect option.
Correct
A troubleshoot option does not exist as data is validated/troubleshoot by using the copy option.
Incorrect
A troubleshoot option does not exist as data is validated/troubleshoot by using the copy option.
-
Question 3 of 10
3. Question
An ideal debugging environment utilises breakpoints to smoothly run an operation. Breakpoints are locations in the code where execution is paused in the debug mode for debugging the data. SSIS provides a list of events to set breakpoint conditions on, from the following options, which of these is NOT a common one?
Correct
OnTaskDelay event is not an option, suitable alternatives would have been OnVariableValueChanged event and adding breakpoint conditions at For Loop and Foreach Loop Containers.
Incorrect
OnTaskDelay event is not an option, suitable alternatives would have been OnVariableValueChanged event and adding breakpoint conditions at For Loop and Foreach Loop Containers.
-
Question 4 of 10
4. Question
In addition to using breakpoints, a Hit Count Type is added for granular control on triggering breakpoints. Various Hit Count settings can be specified for each breakpoint condition. From the following options which of these does NOT describe Hit Count Types?
Correct
Hit Count Sum does not exist, a more suitable alternative would be Hit Count greater than or equal to which is similar to Hit Count Equals.
Incorrect
Hit Count Sum does not exist, a more suitable alternative would be Hit Count greater than or equal to which is similar to Hit Count Equals.
-
Question 5 of 10
5. Question
When a package is suspended due to Breakpoints or Data viewer the Debug > Windows option in Visual Studio menu can display a different menu with options available only during execution time. From the following statements, which of these incorrectly describes the options available in the aforementioned menu?
Correct
Data processing does not come under this menu although it may sound similar to “Locals”
Incorrect
Data processing does not come under this menu although it may sound similar to “Locals”
-
Question 6 of 10
6. Question
To create logs for package execution one should select the Visual Studio Menu > SSIS > Logging. The information stored in logging can be saved in certain locations, when clicking the “Add” button, various locations are displayed to save the logging information. From the options below, please select the incorrect location.
Correct
“Database files” is not one of the options, SQL Server and SQL Server Profiler already cover that location.
Incorrect
“Database files” is not one of the options, SQL Server and SQL Server Profiler already cover that location.
-
Question 7 of 10
7. Question
When data is transferred or moved from a source to a destination, certain issues may arise related to datatype errors and column data truncation. The Error Output page in the “For
Data Flow tasks” provides a way to deal with such issues in 3 ways. From the following, select the incorrect option.Correct
Troubleshooting is done using the debugger and not error output page.
Incorrect
Troubleshooting is done using the debugger and not error output page.
-
Question 8 of 10
8. Question
Usually, when making changes to column mappings some of these mappings go awry and cause issues. When dealing with them a resolved references window can be displayed with a toolbar at the top to expedite resolving column references. From the following list, choose the option that is NOT available in the toolbar.
Correct
Insert Mapping does not exist on the toolbar as automap columns can already fulfil that role.
Incorrect
Insert Mapping does not exist on the toolbar as automap columns can already fulfil that role.
-
Question 9 of 10
9. Question
The SSISDB catalogue and SSISDB database serve as a centralized place where deployed SSIS packages can be stored with everything related to it such as executing and troubleshooting packages. From the list of options below which of these are not related to storing deployed SSIS packages?
Correct
Executing SQL Task services is part of incremental loading and can be implemented via the T-SQL MERGE statement.
Incorrect
Executing SQL Task services is part of incremental loading and can be implemented via the T-SQL MERGE statement.
-
Question 10 of 10
10. Question
You are tasked with creating an SSIDB catalog for a warehouse storage facility. When selecting the Create Catalog window, you are presented with various options. From the following list choose the incorrect option for the aforementioned window.
Correct
The “Enable Backup” option does not exist as there is no need to do create one.
Incorrect
The “Enable Backup” option does not exist as there is no need to do create one.