DP-203 · Question #252
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…
The correct answer is B. Valid. 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…
Question
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.
Options
- AInvalid
- BValid
- CSuggested
- DNew
- ECorrect
- FCorrected
How the community answered
(31 responses)- A13% (4)
- B77% (24)
- D6% (2)
- F3% (1)
Explanation
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 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. https://docs.microsoft.com/en-us/sql/data-quality-services/data-cleansing?view=sql-server-ver15
Topics
Community Discussion
No community discussion yet for this question.