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
In normal cases, SSIS Lookup transform uses the Full Cache Mode. However, for certain requirements, a suitable alternative is T-SQL joins. When determining which one to use, certain scenarios are determined first, such as the efficiency of merge-operations. From the following options, which of these is not a common scenario used to influence the decision making between SSIS and T-SQL?
Correct
The 4 scenarios are Number of lookups, Developer skillsets, organization standards and regulations, and complexity of data transformations and business rules. Organization stock count and sales estimate are not from the scenarios that influence the decision.
Incorrect
The 4 scenarios are Number of lookups, Developer skillsets, organization standards and regulations, and complexity of data transformations and business rules. Organization stock count and sales estimate are not from the scenarios that influence the decision.
-
Question 2 of 10
2. Question
When designing fact tables for data warehouses in large amounts certain practices are implemented to design an optimal fact table. Which of the following options is not from the patterns that provide a suitable design for a fact table?
Correct
Removing sensitive data upon saving is an SSIS Package called DontSaveSensitive, it is not a part of patterns that provide a suitable design for a fact table.
Incorrect
Removing sensitive data upon saving is an SSIS Package called DontSaveSensitive, it is not a part of patterns that provide a suitable design for a fact table.
-
Question 3 of 10
3. Question
SSIS Incremental Load refers to comparing a target table with a source of data usually based on IDs or Time Stamps. Should there be any new records in the source data, they are entered into the target table’s records. Which of the following does not correctly describe incremental loading using SSIS?
Correct
CDC Control Task is a method used to “Change Data Capture” for incremental loading within SSIS not Create Database Content.
Incorrect
CDC Control Task is a method used to “Change Data Capture” for incremental loading within SSIS not Create Database Content.
-
Question 4 of 10
4. Question
A company recently installed the MDSModelDeploy tool to train its new employees. It further wishes to utilize the other three packages that were included with the installation of Master Data Services. From the options below, which of these is NOT a part of the three aforementioned packages?
Correct
employee_en.pkg does not exist, the other three options are the actual packages that are included with the installation of Master Data Services.
Incorrect
employee_en.pkg does not exist, the other three options are the actual packages that are included with the installation of Master Data Services.
-
Question 5 of 10
5. Question
To use CDC for automatic incremental load processing, specific tasks need to be completed first. For example, the CDC process fails to proceed if the SQL Agent has been turned off.
From the following options which of these is NOT a change tracked by CDC?Correct
CDC does not track the increase in the use of storage by row modification, instead it tracks the rows inserted.
Incorrect
CDC does not track the increase in the use of storage by row modification, instead it tracks the rows inserted.
-
Question 6 of 10
6. Question
A company requires you to load data by utilizing Transact-SQL CDC functions. For the database, CDC is enabled on each table to be tracked and individual columns are also configured to be tracked. Choose from the following options, the incorrect statement when describing the CDC function.
Correct
The default retention period is 3 days, after which an SQL Server Agent job removes the rows from the CDC table, although this retention period may be customized.
Incorrect
The default retention period is 3 days, after which an SQL Server Agent job removes the rows from the CDC table, although this retention period may be customized.
-
Question 7 of 10
7. Question
Auditing companies use CDC to track financial transactions and provide more efficiency for auditing. Considering that the basic structure of the CDC Control Flow package does not differ for an Initial, full load and Incremental load, which of the following options is not a part of the basic structure for CDC?
Correct
The final step involves using the CDC Control Task to mark the end of the process, not verifying the information. As the basic structure is, Cleaning out Staging Table –> Starting Initial/Full load/Incremental load for CDC Control Task –> Loading the Initial/Full load/Incremental load –> Ending the Initial/Full load/Incremental load.
Incorrect
The final step involves using the CDC Control Task to mark the end of the process, not verifying the information. As the basic structure is, Cleaning out Staging Table –> Starting Initial/Full load/Incremental load for CDC Control Task –> Loading the Initial/Full load/Incremental load –> Ending the Initial/Full load/Incremental load.
-
Question 8 of 10
8. Question
A British Library Agency requires you to utilize the CDC Control Task Editor and update their inventory for the list of books in 2020. Which of the following options are not in the CDC Control Task Editor that you would specify?
Correct
Instead of the library location, the table used for storing the state of the current CDC value is specified. Another specification could be to specify the CDC Control Operation.
Incorrect
Instead of the library location, the table used for storing the state of the current CDC value is specified. Another specification could be to specify the CDC Control Operation.
-
Question 9 of 10
9. Question
An auditing firm in Scandanavia requires you to finalize the CDC Control Operations for their SQL Database. A number of options are presented on the CDC Control Operations drop-down menu, which of the following choices depicts these options incorrectly?
Correct
Mark CDC End is not one of the available options, the other 2 remaining options are Get Processing Range and Marked Processing Range.
Incorrect
Mark CDC End is not one of the available options, the other 2 remaining options are Get Processing Range and Marked Processing Range.
-
Question 10 of 10
10. Question
When dealing with CDC Control Task, three major components of CDC deal with primary functions such as handling error scenarios and recovery. From the following options, which of these is NOT a primary function of the three major components of CDC?
Correct
The primary function is to handle the CDC package state in an SSIS package variable. A transact-SQL variable is a set of programming extensions and not an SSIS package.
Incorrect
The primary function is to handle the CDC package state in an SSIS package variable. A transact-SQL variable is a set of programming extensions and not an SSIS package.