🌍 All Study Guides 📊 Dashboard 📰 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.

processing

publishing

reportingCorrect Answer

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?

Visualizing the data

Seeing the big pictureCorrect Answer

Reporting on the data

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?

SNIP

REMOVE

CLEAR

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?

COUNTACorrect Answer

COUNT

CHECK

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?

DocumentationCorrect Answer

Illumination

Disclosure

Examination

Explanation:

A changelog supports documentation.

QUESTION 6 OF 35

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

True

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?

Inform others of your data-cleaning effort

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 nowCorrect Answer

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?

TRIMCorrect Answer

CROP

TIDY

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?

CASECorrect Answer

WHEN

THEN

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.

approximate

random

synchronized

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.

TrueCorrect Answer

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.

Consider the business problemCorrect Answer

Consider the dataCorrect Answer

Consider the goalCorrect Answer

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.

LeadingCorrect Answer

RepeatedCorrect Answer

inner

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?

DocumentationCorrect Answer

Cataloging

Recording

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?

While cleaning the dataCorrect Answer

While visualizing the data

While gathering the data

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?

Determine the quality of the data

Compare cleaned data with the original, uncleaned dataset and compare it to what is there nowCorrect Answer

Create a chronological list of modifications made to the data

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?

TIDY

TRIMCorrect Answer

CROP

CUT

QUESTION 18 OF 35

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

CONFIRM

CASE

COUNT

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?

CASECorrect Answer

THEN

WHEN

ELSE

QUESTION 20 OF 35

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

Changes, resolutions, and deletions

Errors, deletions, and notesCorrect Answer

Errors, additions, and deletions

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

manipulation

publishing

verificationCorrect Answer

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?

COUNT

CASE

CHECK

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.

changes

fields

identifications

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.

documentation

presenting

verificationCorrect Answer

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.

TrueCorrect Answer

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

verificationCorrect Answer

manipulation

replacing

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.

Consider the stakeholders

Consider the reporting

Consider the business problemCorrect Answer

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?

CASE

CHECK

COUNT

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?

ChangelogCorrect Answer

Metadata

Spreadsheet

Notepad

QUESTION 30 OF 35

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

The total number of values within a specified rangeCorrect Answer

The total number of headers in a specific range

The specific numbers in a dataset

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?

CASECorrect Answer

THEN

WHEN

ELSE

QUESTION 32 OF 35

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

inactivity

changesCorrect Answer

additionsCorrect Answer

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.

notepad

spreadsheet

changelogCorrect Answer

database

QUESTION 34 OF 35

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

Publishing

Processing

Confirming

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.

Consider the reporting

Consider the goalCorrect Answer

Consider the business problemCorrect Answer

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.

processing

publishing

reporting

confirming

How confident are you in this answer?