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
- COUNT
- COUNTA
- CHECK
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
