Week 4 – Verify and report on your cleaning results – Shuffle Q/A 2

21. Fill in the blank: A changelog contains a _____ list of modifications made to a project.

  • random
  • approximate
  • chronological
  • synchronized

22. You start a complex project that will take more than a year to complete. You need to document modifications made to your queries throughout the project. What is the correct way to store these modifications?

  • Creating a changelog
  • Creating a notepad
  • Visualizing data
  • Creating a spreadsheet

23. Fill in the blank: A process to confirm that a data-cleaning effort was well-executed and the resulting data is accurate and reliable is known as _____.

  • verification
  • publishing
  • manipulation
  • processing

24. A data analyst is in the verification step. They consider the business problem, the goal, and the data involved in their analytics project. What scenario does this describe?

  • Reporting on the data
  • Considering the stakeholders
  • Seeing the big picture
  • Visualizing the data

25. During data cleaning, you find an error in a username where the ID number was accidentally joined to the user’s last name. You need to figure out if this username has been entered incorrectly more than once in your datasett. If you use a pivot table, what function can you use to determine the number of times this error occurs in your dataset?

  • CASE

26. You’re working with a dataset that contains categorical variables. You notice that some of the strings are misspelled or are not capitalized. What function can you use to fix these errors when a condition is met?

  • ELSE
  • CASE
  • WHEN
  • THEN

27. A data analyst uses a changelog while cleaning data. What process does a changelog support?

  • Illumination
  • Examination
  • Disclosure
  • Documentation

28. A changelog is essential for storing chronological modifications made during the data cleaning process. When will an analyst refer to the information in the changelog to certify data integrity?

  • Documentation
  • Verification
  • Presenting
  • Visualization

Shuffle Q/A 3

29. Fill in the blank: As a data analyst, you should always create a _____ to track your additions, deletions, errors, and changes to a query.

  • notepad
  • database
  • changelog
  • spreadsheet

30. Fill in the blank: TRIM is a function that removes _____ spaces in data. Select all that apply.

  • repeated
  • trailing
  • leading
  • inner

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply