Machine-translated by Google. Questions are authored in English.
Top

Discussion

Data scrubbing is which of the following?

  • A.A process to reject data from the data warehouse and to create the necessary indexes
  • B.A process to load the data in the data warehouse and to create the necessary indexes
  • C.A process to upgrade the quality of data after it is moved into a data warehouse
  • D.A process to upgrade the quality of data before it is moved into a data warehouse

Answer: D

Correct answer: A process to upgrade the quality of data before it is moved into a data warehouse

Scrubbing happens on the way in, during the transformation stage, because the warehouse is meant to be the trustworthy source and cleaning it afterwards would mean queries had already run against bad data. It corrects misspellings, resolves conflicting codes and fills or flags missing values.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.