31. While verifying cleaned data, a data analyst encounters a misspelled name. Which function can they use to determine the number of misspelled occurrences in the dataset?
- CASE
- CHECK
- CHECK
- COUNTA
32. At what point during the analysis process does a data analyst use a changelog?
- While cleaning the data
- While visualizing the data
- While gathering the data
- While reporting the data
33. Your manager points out an error in a product ID number in your dataset. The Product IDs can be numbers like 42 or text like "CAD-425". Using a pivot table, what function can you use to find how many times this error occurs in the dataset?
- COUNT
- CHECK
- COUNTA
- CASE
34. While reviewing your coworker’s data cleaning process, you find a few cases of trailing spaces in the data. What function can you use to remove these spaces?
- REMOVE TRAILING
- DELETE
- CUT
- TRIM
35. Which of the following queries considers one or more conditions and returns a value as soon as that condition is met?
- SELECT * WHEN CASE COLUMN = VARIABLE
- SELECT * CASE IF COLUMN = VARIABLE
- SELECT * CASE WHEN COLUMN = VARIABLE
- SELECT * IF CASE COLUMN = VARIABLE
36. Fill in the blank: Once data is clean, a data analyst moves on to _____ and verification.
- processing
- confirming
- publishing
- reporting
37. A data analyst is starting a large scale project. The project will be crucial to business success and the data analyst needs to keep the big picture at the forefront when verifying their data cleaning. What is the first step in the verification process?
- Create a chronological list of modifications made to the data
- Compare cleaned data with the original, uncleaned dataset and compare it to what is there now
- Inform others of the data-cleaning effort
- Determine the quality of the data
38. You use SQL to clean your data. You make comments whenever you modify your queries to keep track of any changes. What documentation will this practice help you create when you’re done cleaning the data?
- A changelog
- A query repository
- A new dataset
- A database
39. A data analyst is starting a large scale project that is crucial to business success. The data analyst needs to remember the big picture when verifying their data cleaning. What is involved when focusing on the big picture-view of the project? Select all that apply.
- Consider the reporting
- Consider the business problem
- Consider the stakeholders
- Consider the goal
