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 creating an SSIS Catalog certain properties can be configured. From the following options which of these is an incorrect property?
Correct
Automatically Remove Old Versions is incorrect, rather Periodically Remove Old Versions –> Chooses how many versions to retain
Incorrect
Automatically Remove Old Versions is incorrect, rather Periodically Remove Old Versions –> Chooses how many versions to retain
-
Question 2 of 10
2. Question
SSDT can be used to create an ISPAC project deployment file, allowing deploying of packages into production without developer involvement. When designing Project deployment you are presented with a few options, which of the following statements incorrectly describes these options?
Correct
Although “Package name” does allow you to select the checkboxes for each of the packages to deploy it is a part of package deployment and not project deployment.
Incorrect
Although “Package name” does allow you to select the checkboxes for each of the packages to deploy it is a part of package deployment and not project deployment.
-
Question 3 of 10
3. Question
An auditing firm requires you to design a “Package deployment” when using the Integration Services Deployment Wizard, you are presented with multiple options. From the following statements, which of these is NOT an option for Package Deployment?
Correct
When choosing package deployment the package files are installed in the target folder path location and it does not create ISPAC files in the specific location.
Incorrect
When choosing package deployment the package files are installed in the target folder path location and it does not create ISPAC files in the specific location.
-
Question 4 of 10
4. Question
After a package is deployed it has to be executed to perform all the tasks contained in the package. The execution is achieved in multiple ways, from the following options, select the incorrect method in executing packages.
Correct
DTExec –> Runs a command-line utility that executes the package from the script NOT CSPrompt
Incorrect
DTExec –> Runs a command-line utility that executes the package from the script NOT CSPrompt
-
Question 5 of 10
5. Question
An organization requires you to run an “Execute Package Utility” by providing all the values and information. From the following options, which of these is not commonly provided information for the execute package utility?
Correct
The current Operating System version is not commonly provided to the execute package utility.
Incorrect
The current Operating System version is not commonly provided to the execute package utility.
-
Question 6 of 10
6. Question
When installing the Data Quality Services a password is created as the database master key. As part of the installation process, 3 databases are created on the SQL Server Database Engine. Which of the following options is not one of the 3 databases?
Correct
DQS_SERVER does not exist, as it’s creating a database instance, server selection is enabled inside the database.
Incorrect
DQS_SERVER does not exist, as it’s creating a database instance, server selection is enabled inside the database.
-
Question 7 of 10
7. Question
In most cases, a Data Quality Services knowledge base is created as a new and empty base or existing knowledge is imported from a DQS file. A company requires you to create a new DQS knowledge base without importing information, which of the following options would NOT be a part of the steps in creating one.
Correct
Choosing the Use Leading Values option is part of domain management when creating a DQS domain.
Incorrect
Choosing the Use Leading Values option is part of domain management when creating a DQS domain.
-
Question 8 of 10
8. Question
A knowledge base usually consists of domains which represent the data in a data field. As part of a University assignment, you are tasked with creating a DQS domain for a list of suppliers. Which of the following would NOT be a step in doing so?
Correct
Selecting None from the Create Knowledge Base dropdown list is part of creating a new and empty DQS knowledge base.
Incorrect
Selecting None from the Create Knowledge Base dropdown list is part of creating a new and empty DQS knowledge base.
-
Question 9 of 10
9. Question
When setting up Domain Management, certain rules can be established in the Domain Rules tab, these, for example, regulate the length of domain values. Which of the following statements incorrectly describes Domain Values?
Correct
Synonym values CAN be set as Leading values, these are used by DQS to replace other synonym values found in the data during cleansing activities.
Incorrect
Synonym values CAN be set as Leading values, these are used by DQS to replace other synonym values found in the data during cleansing activities.
-
Question 10 of 10
10. Question
An organization requires you to add matching knowledge to a knowledge base using DQS knowledge base, essentially this benefits in maintaining unique lists as Suppliers, Products and Customers. Which of the following statements incorrectly describes DQS knowledge base matching?
Correct
The minimum matching score for DQS is 50%, this can be set in the Administration > Configuration > General Settings section.
Incorrect
The minimum matching score for DQS is 50%, this can be set in the Administration > Configuration > General Settings section.