Week 4 – Verify and report on your cleaning results

process data from dirty to clean weekly challenge 4 answers

1. Verification and reporting come directly before the data-cleaning process.

  • True
  • False

2. What is the first step in the verification process?

  • Compare cleaned data with the original, uncleaned dataset and compare it to what is there now
  • Create a chronological list of modifications made to the data
  • Determine the quality of the data
  • Inform others of your data-cleaning effort

3. Which of the following functions automatically remove extra spaces when cleaning data?

  • SNIP
  • TRIM


4. What tool can a data analyst use to figure out how many identical errors occur in a dataset?

  • CASE

5. Fill in the blank: A data analyst uses the CASE statement to consider one or more _____, then returns a value.

  • additions
  • conditions
  • identifications
  • changes

6. What is the process of tracking changes, additions, deletions, and errors during data cleaning?

  • Recording
  • Observation
  • Cataloging
  • Documentation

7. Fill in the blank: While cleaning data, a data analyst can use a changelog to keep a chronological list of changes they make. They can refer to it during the _____ period if there are errors or questions.

  • presenting
  • verification
  • documentation
  • visualization

8. Reviewing version history is an effective way to view a changelog in SQL.

  • True
  • False


Shuffle Q/A 1

9. In what step of the data-cleaning process do you find mistakes before you begin analyzing the data?

  • Confirming
  • Publishing
  • Verifying
  • Processing

10. During the data cleaning process you find a significant amount of data that contains irrelevant spaces. Which function do you use to remove leading, trailing, or repeated spaces?

  • CUT
  • TRIM
  • TIDY

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply