Monica has been working with her IT department to capture user data from online profiles potential customers create on the company's website. Monica is working on a project to build internal customer profiles so that they can tailor offers and target emails to unique preferences. After she receives an Excel document, she realizes that there appear to be some erroneous records and duplicate entries and that some required fields are blank. What stage of the data cleaning process will correct these errors?
A) The rinse cycle since these appear to be mid-level errors that will take a medium level of effort to correct.
B) The scrub cycle since these appear to be deeper errors that will necessitate a deeper study and one-at-a-time manual corrections.
C) The steam cycle since these appear to be errors of little concern and therefore can be left alone without impact.
D) The wash cycle since these appear to be obvious errors that will require minimum effort to correct.

Question

Quizplus · Accepted Answer

This question requires familiarity with data collection and the processes entailed with its retrieval. Choice B is correct because the errors described within this problem will require the methods involved in the scrub cycle since they would require in-depth correction. The remaining choices are incorrect because they are not proper alignments of parts of the cycle to the difficulty levels or they do not represent the place in the data cleaning cycle that type of error would be addressed.

Monica Has Been Working with Her IT Department to Capture