Data Cleansing in Data Quality Services (DQS) includes a 2-step process for data cleansing: computer-assisted and interactive cleansing.
Depending upon the computer-assisted cleansing process, during the interactive cleansing, DQS gives the data steward with information that is needed to make a decision about modifying or changing the data.
For this purpose, DQS classifies the data into 5 tabs.
From the below-given option, choose the tab that is not among these tabs.
Click on the arrows to vote for the correct answer
A. B. C. D. E. F.Correct Answer: B
During the interactive cleansing, Data Quality Services (DQS) classifies the data in these 5 tabs: Suggested, New, Invalid, Corrected, and Correct.
Option A is incorrect.
Invalid tab has the values that were specified as invalid in the domain in the knowledge base or values that failed reference data or a domain rule.
Option B is correct.
There is no such tab with the name valid.
Option C is incorrect.
The suggested tab consists of the values having a confidence level greater than the auto-suggestion threshold value but lesser than the auto-correction threshold value for which Data Quality Services (DQS) found suggestions.
Option D is incorrect.
The new tab consists of the valid values for which Data Quality Services (DQS) doesn't have sufficient information (suggestion), and hence can't be mapped to any other tab.
Option E is incorrect.
The correct tab is for the values which were found correct.
Option F is incorrect.
The corrected tab is for the values that are corrected by Data Quality Services (DQS) during the automated cleansing.
To know more about data cleansing, please visit the below-given link:
Data Quality Services (DQS) is a feature in Microsoft SQL Server that allows users to cleanse and manage data quality. The data cleansing process in DQS includes two steps, computer-assisted and interactive cleansing. The computer-assisted process uses algorithms to automatically identify and correct errors in the data, while the interactive cleansing process involves human intervention to correct data issues that cannot be resolved by the computer-assisted process.
During the interactive cleansing process, DQS presents the data steward with information about the data that needs to be modified or changed. This information is presented in the form of tabs, which organize the data into different categories based on its characteristics. There are five tabs that are used in the interactive cleansing process:
Invalid: This tab displays data that does not meet the rules and constraints defined in the DQS knowledge base. For example, if the knowledge base specifies that a phone number must have ten digits, any phone number with fewer or more than ten digits will be classified as invalid.
Valid: This tab displays data that meets the rules and constraints defined in the DQS knowledge base. For example, if the knowledge base specifies that a postal code must be in a specific format, any postal code that matches that format will be classified as valid.
Suggested: This tab displays data that DQS suggests may need to be modified or corrected based on the data steward's input. For example, if the knowledge base contains a list of valid countries, any data that does not match a valid country will be classified as suggested.
New: This tab displays data that is not currently in the knowledge base and needs to be added. For example, if the data steward encounters a new product name, they can add it to the knowledge base so that DQS can recognize it in the future.
Corrected: This tab displays data that has been modified or corrected by the data steward during the interactive cleansing process.
Therefore, the tab that is not among these tabs is F. Corrected. All the other tabs, including Invalid, Valid, Suggested, and New, are used to classify data during the interactive cleansing process in DQS.