4.4.3.Weekly challenge 4 - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki
Weekly challenge 4
LATEST SUBMISSION GRADE 100%
Question 1
The data collected for an analysis project has just been cleaned. What are the next steps for a data analyst? Select all that apply.
- Reporting
Certification- Verification
Validation
Correct. Verification and reporting are the next steps for a data analyst after the data is cleaned.
Question 2
What is involved in seeing the big picture when verifying data cleaning? Select all that apply.
- Consider the data.
Consider the reporting.- Consider the goal.
- Consider the business problem.
Correct. To see the big picture when verifying data cleaning, consider the business problem, the goal, and the data.
Question 3
Which of the following functions automatically remove extra spaces when cleaning data?
- TRIM
CLEARREMOVESNIP
Correct. TRIM
automatically removes extra spaces when cleaning data.
Question 4
What tool can a data analyst use to figure out how many identical errors occur in a dataset?
CONFIRMCOUNT- COUNTA
CASE
Correct. A data analyst can use COUNTA
to figure out how many identical errors occur in a dataset.
Question 5
A WHEN statement considers one or more conditions and returns a value as soon as that condition is met.
True- False
Correct. A CASE
statement considers one or more conditions and returns a value as soon as that condition is met.
Question 6
What is the process of tracking changes, additions, deletions, and errors during data cleaning?
ObservationCataloging- Documentation
Recording
Correct. Documentation is the process of tracking changes, additions, deletions, and errors during data cleaning.
Question 7
At what point during the analysis process does a data analyst use a changelog?
While reporting the dataWhile gathering the data- While cleaning the data
While visualizing the data
Correct. A data analyst uses a changelog while cleaning data.
Question 8
A data analyst commits a query to the repository as a new and improved query. Then, they specify the changes they made and why they made them. This scenario is part of what process?
Visualizing data- Creating a changelog
Reporting dataCommunicating with stakeholders
Correct. Specifying the changes an analyst made and why they made them is part of creating a changelog.
EXTRA QUESTIONS
Question
What is the first step in the verification process?
Inform others of your data-cleaning effort.Create a chronological list of modifications made to the data.Determine the quality of the data.- Compare cleaned data with the original, uncleaned dataset and compare it to what is there now.
Correct. The first step in the verification process is to compare cleaned data with the original, uncleaned dataset and compare it to what is there now.
Question
Fill in the blank: A changelog contains a _____ list of modifications made to a project.
- chronological
synchronizedapproximaterandom
Correct. A data analyst uses a changelog to access the information needed. A changelog is a file that contains a chronological list of modifications made to a project.