QuiztudyPREMIUM
🌍 All Study Guides📰 Blog💡 About
Google Data Analytics Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 35

Fill in the blank: Once data is clean, a data analyst moves on to _____ and verification.

A
processing
B
publishing
C
reportingCorrect Answer
D
confirming
Explanation:

Once data is clean, a data analyst moves on to reporting and verification.

QUESTION 2 OF 35

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?

A
Visualizing the data
B
Seeing the big pictureCorrect Answer
C
Reporting on the data
D
Considering the stakeholders
Explanation:

To see the big picture when verifying data cleaning, consider the business problem, the goal, and the data.

QUESTION 3 OF 35

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

A
SNIP
B
REMOVE
C
CLEAR
D
TRIMCorrect Answer
Explanation:

TRIM automatically removes extra spaces when cleaning data.

QUESTION 4 OF 35

While verifying cleaned data, a data analyst encounters a misspelled name. Which function can they use to determine if the error is repeated throughout the dataset?

A
COUNTACorrect Answer
B
COUNT
C
CHECK
D
CASE
Explanation:

To determine if the error is repeated throughout the dataset, they can use COUNTA.

QUESTION 5 OF 35

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

A
DocumentationCorrect Answer
B
Illumination
C
Disclosure
D
Examination
Explanation:

A changelog supports documentation.

QUESTION 6 OF 35

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

A
True
B
FalseCorrect Answer
Explanation:

Review the video that introduces verification and reporting for a refresher.

QUESTION 7 OF 35

What is the first step in the verification process?

A
Inform others of your data-cleaning effort
B
Create a chronological list of modifications made to the data
C
Compare cleaned data with the original, uncleaned dataset and compare it to what is there nowCorrect Answer
D
Determine the quality of the data
Explanation:

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 8 OF 35

Which function removes leading, trailing, and repeated spaces in data?

A
TRIMCorrect Answer
B
CROP
C
TIDY
D
CUT
Explanation:

TRIM is a function that removes leading, trailing, and repeated spaces in data.

QUESTION 9 OF 35

Which SQL tool considers one or more conditions, then returns a value as soon as a condition is met?

A
CASECorrect Answer
B
WHEN
C
THEN
D
ELSE
Explanation:

CASE considers one or more conditions, then returns a value as soon as a condition is met.

QUESTION 10 OF 35

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

A
approximate
B
random
C
synchronized
D
chronologicalCorrect Answer
Explanation:

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.

QUESTION 11 OF 35

A data analyst makes changes to SQL queries and uses these comments to create a changelog. This involves specifying the changes they made and why they made them.

A
TrueCorrect Answer
B
False
Explanation:

A data analyst making changes to SQL queries and using these comments to create a changelog involves specifying the changes they made and why they made them.

QUESTION 12 OF 35

What is involved in seeing the big picture when verifying data cleaning? Select all that apply.

A
Consider the business problemCorrect Answer
B
Consider the dataCorrect Answer
C
Consider the goalCorrect Answer
D
Consider the reporting
Explanation:

To see the big picture when verifying data cleaning, consider the business problem, the goal, and the data.

QUESTION 13 OF 35

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

A
LeadingCorrect Answer
B
RepeatedCorrect Answer
C
inner
D
trailingCorrect Answer
Explanation:

TRIM is a function that removes leading, trailing, and repeated spaces in data.

QUESTION 14 OF 35

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

A
DocumentationCorrect Answer
B
Cataloging
C
Recording
D
Observation
Explanation:

Documentation is the process of tracking changes, additions, deletions, and errors during data cleaning.

QUESTION 15 OF 35

At what point during the analysis process does a data analyst use a changelog?

A
While cleaning the dataCorrect Answer
B
While visualizing the data
C
While gathering the data
D
While reporting the data
Explanation:

A data analyst uses a changelog while cleaning data.

QUESTION 16 OF 35

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?

A
Determine the quality of the data
B
Compare cleaned data with the original, uncleaned dataset and compare it to what is there nowCorrect Answer
C
Create a chronological list of modifications made to the data
D
Inform others of the data-cleaning effort
QUESTION 17 OF 35

During the verification process, you find that you missed a few leading spaces during data cleaning. What function can you use to eliminate these spaces?

A
TIDY
B
TRIMCorrect Answer
C
CROP
D
CUT
QUESTION 18 OF 35

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

A
CONFIRM
B
CASE
C
COUNT
D
COUNTACorrect Answer
QUESTION 19 OF 35

You find a few misspellings in your datatable and need to correct them when running a query. What function can you use when your set condition is met?

A
CASECorrect Answer
B
THEN
C
WHEN
D
ELSE
QUESTION 20 OF 35

A data analyst uses a changelog while cleaning their data. What data modifications should they track in the changelog?

A
Changes, resolutions, and deletions
B
Errors, deletions, and notesCorrect Answer
C
Errors, additions, and deletions
D
Additions, changes, and queries
QUESTION 21 OF 35

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 _____.

A
manipulation
B
publishing
C
verificationCorrect Answer
D
processing
QUESTION 22 OF 35

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 dataset. If you use a pivot table, what function can you use to determine the number of times this error occurs in your dataset?

A
COUNT
B
CASE
C
CHECK
D
COUNTACorrect Answer
QUESTION 23 OF 35

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

A
changes
B
fields
C
identifications
D
conditionsCorrect Answer
QUESTION 24 OF 35

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.

A
documentation
B
presenting
C
verificationCorrect Answer
D
visualization
QUESTION 25 OF 35

A data analyst is reviewing modifications made to a SQL table and a spreadsheet. The data analyst will get similar results when using the changelogs for both data sources.

A
TrueCorrect Answer
B
False
QUESTION 26 OF 35

Fill in the blank: A data analyst finishes cleaning their data. The next step in the process is reporting and ____.

A
verificationCorrect Answer
B
manipulation
C
replacing
D
processing
QUESTION 27 OF 35

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.

A
Consider the stakeholders
B
Consider the reporting
C
Consider the business problemCorrect Answer
D
Consider the goalCorrect Answer
QUESTION 28 OF 35

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?

A
CASE
B
CHECK
C
COUNT
D
COUNTACorrect Answer
QUESTION 29 OF 35

A data analyst is in the verification process and needs to verify the modifications that they have made to the data. What could the analyst reference to find the changes they made throughout data cleaning?

A
ChangelogCorrect Answer
B
Metadata
C
Spreadsheet
D
Notepad
QUESTION 30 OF 35

A data analyst uses the COUNTA function to count which of the following?

A
The total number of values within a specified rangeCorrect Answer
B
The total number of headers in a specific range
C
The specific numbers in a dataset
D
The total number of entries in a changelog
QUESTION 31 OF 35

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?

A
CASECorrect Answer
B
THEN
C
WHEN
D
ELSE
QUESTION 32 OF 35

Fill in the blank: Documentation is the process of tracking _____ during data cleaning. Select all that apply.

A
inactivity
B
changesCorrect Answer
C
additionsCorrect Answer
D
deletionsCorrect Answer
QUESTION 33 OF 35

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

A
notepad
B
spreadsheet
C
changelogCorrect Answer
D
database
QUESTION 34 OF 35

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

A
Publishing
B
Processing
C
Confirming
D
VerifyingCorrect Answer
QUESTION 35 OF 35

As a data analyst, you will need to keep the big picture in mind throughout any project when verifying data cleaning. What must the analyst do to take a big picture view of the project? Select all that apply.

A
Consider the reporting
B
Consider the goalCorrect Answer
C
Consider the business problemCorrect Answer
D
Consider the dataCorrect Answer

Ready to test your recall?

Fill in the blank: Once data is clean, a data analyst moves on to _____ and verification.

A
processing
B
publishing
C
reporting
D
confirming

How confident are you in this answer?