🌍 All Study Guides 📊 Dashboard 📰 Blog 💡 About

Google Data Analytics Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 25

During which of the four phases of analysis can you find a correlation between two variables? Explanation : Finding a correlation between two variables occurs while transforming data.

Format and adjust data

Organize data

Transform dataCorrect Answer

Get input from others

QUESTION 2 OF 25

Typically, a data analyst uses filters when they want to expand the amount of data they are working with.

True

FalseCorrect Answer

Explanation:

Typically, a data analyst uses filters when they want to narrow down the amount of data they are working with.

QUESTION 3 OF 25

A data analyst sorts a spreadsheet range between cells F19 and G82. They sort in ascending order by the second column, Column G. What is the syntax they are using?

=SORT(F19:G82, 2, FALSE)

=SORT(F19:G82, B, TRUE)

=SORT(F19:G82, 2, TRUE)Correct Answer

=SORT(F19:G82, B, FALSE)

Explanation:

The correct syntax is =SORT(F19:G82, 2, TRUE). The first part of the function sorts the data in the specified range. The 2 represents the second column. And a TRUE statement sorts in ascending order.

QUESTION 4 OF 25

Which phase of the data analysis process has the goal of identifying trends and relationships?

AnalyzeCorrect Answer

Process

Act

Prepare

Explanation:

The goal of analysis is to identify trends and relationships within that data so you can accurately answer the question you’re asking.

QUESTION 5 OF 25

Which of the following actions might occur when transforming data? Select all that apply.

Recognize relationships in your dataCorrect Answer

Eliminate irrelevant info from your data

Make calculations based on your dataCorrect Answer

Identify a pattern in your dataCorrect Answer

Explanation:

Transforming data means identifying relationships and patterns between the data, and making calculations based on the data you have.

QUESTION 6 OF 25

Fill in the blank: Sorting ranks data based on a specific _____ that you select.

model

calculation

observation

metricCorrect Answer

Explanation:

Sorting ranks data based on a specific metric that you select. This involves arranging the data into a meaningful order to make it easier to understand, analyze, and visualize.

QUESTION 7 OF 25

A data analyst is sorting data in a spreadsheet. Which tool are they using if all of the data is sorted by the ranking of a specific sorted column and data across rows is kept together?

Sort SheetCorrect Answer

Sort Together

Sort Document

Sort Rank

Explanation:

Sort sheet sorts all of the data in a spreadsheet by the ranking of a specific sorted column. Also, data across rows is kept together.

QUESTION 8 OF 25

You are querying a database that contains data about music. You are only interested in data related to the jazz musician Miles Davis. The names of the musicians are listed in the composer column. You write the SQL query below. Add a WHERE clause that will return only data about music by Miles Davis. What track by Miles Davis appears in row 1 of your query result?

So What

Summertime

Compulsion

Now's The TimeCorrect Answer

Explanation:

The clause WHERE composer = "Miles Davis" will return only data about music by Miles Davis. The complete query is SELECT * FROM track WHERE composer = “Miles Davis”. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. The track Now's The Time by Miles Davis appears in row 1 of your query result.

QUESTION 9 OF 25

A data analyst at a high-tech manufacturer sorts inventory data in a spreadsheet. They sort all data by ranking in the Order Frequency column, keeping together all data across rows. What spreadsheet tool are they using?

Sort Rows

Sort Column

Sort Together

Sort SheetCorrect Answer

QUESTION 10 OF 25

Fill in the blank: To filter for all students in the Sophomore table who live in Fairfield County, a data professional uses the _____ clause in SQL.

LIMIT

EXCEPT

FILTER

WHERECorrect Answer

QUESTION 11 OF 25

A junior data analyst performs several calculations on a dataset. What phase of analysis is the analyst in?

Get input from others

Format and adjust data

Organize data

Transform dataCorrect Answer

QUESTION 12 OF 25

Which of the following statements accurately describe sorting and filtering? Select all that apply.

Filtering can be performed in spreadsheets, but not SQL databases.

Filtering enables data professionals to view the data that is most important.Correct Answer

Sorting involves arranging data into a meaningful order.Correct Answer

Sorting can be performed in both spreadsheets and SQL databases.Correct Answer

QUESTION 13 OF 25

Fill in the blank: During an analysis project, _____ might involve creating new columns in order to prepare the dataset for analysis.

formatting and adjusting dataCorrect Answer

organizing data

getting input from others

transforming data

QUESTION 14 OF 25

Which query will return a list of all construction businesses that have made more than $8 million, in order from the largest number of employees to the fewest? 2 FROM 'Company_data' 3 WHERE Business = 'Construction', Revenue < 8000000 4 ORDER BY number_of_employees ASC 2 FROM 'Company_data' 3 WHERE Business = 'Construction' 4 AND Revenue > 8000000 5 ORDER BY number_of_employees DSC 2 FROM 'Company_data' 3 WHERE Business = 'Construction' 4 WHERE Revenue < 8000000 5 ORDER BY number_of_employees DSC 2 FROM 'Company_data' 3 WHERE Business = 'Construction' 4 AND Revenue > 8000000 5 ORDER BY number_of_employees ASC (CORRECT)

1 SELECTCorrect Answer

QUESTION 15 OF 25

A data professional at a manufacturing company is tasked with identifying which machines are most likely to need repairs. In the analyze phase of the data analysis process, what activities might this involve? Select all that apply.

Prepare a report for the stakeholders

Organize a dataset by machine type and performance levelsCorrect Answer

Get input from colleagues on the data teamCorrect Answer

Format the data to filter for machines that need the most maintenanceCorrect Answer

QUESTION 16 OF 25

Which function sorts a spreadsheet range between cells K1 and L80 in ascending order by the first column, Column K?

=SORT(K1:L80, A, TRUE)

=SORT(K1:L80, A, FALSE)

=SORT(K1:L80, 1, TRUE)Correct Answer

=SORT(K1:L80, 1, FALSE)

QUESTION 17 OF 25

A data analyst determines whether there are any patterns in a dataset. What phase of analysis is the analyst in?

Format and adjust data

Organize data

Transform dataCorrect Answer

Get input from others

QUESTION 18 OF 25

Which function sorts a spreadsheet range between cells C1 and D70 in ascending order by the first column, Column C?

=SORT(C1:D70, A, TRUE)

=SORT(C1:D70, 1, FALSE)

=SORT(C1:D70, 1, TRUE)Correct Answer

=SORT(C1:D70, A, FALSE)

QUESTION 19 OF 25

A data analyst at a retail company sorts customer data in a spreadsheet. They sort all data by ranking in the Purchase Amount column, keeping together all data across rows. What spreadsheet tool are they using? 20 . Fill in the blank: To filter for all items in the Products table that are currently in stock, a data professional uses the _____ clause in SQL.

Sort Document

Sort SheetCorrect Answer

Sort Together

Sort Rank

LIMIT

FILTER

EXCEPT

WHERECorrect Answer

QUESTION 20 OF 25

Fill in the blank: During an analysis project, _____ might involve converting dates to a consistent format in order to prepare the dataset for analysis.

transforming data

formatting and adjusting data

getting input from othersCorrect Answer

organizing data

QUESTION 21 OF 25

A data professional in human resources is tasked with identifying appropriate staff members to manage upcoming projects. In the analyze phase of the data analysis process, what activities might this involve? Select all that apply.

Prepare a report for the stakeholders

Get input from other HR data professionalsCorrect Answer

Format the data to filter for keywords relevant to the upcoming projectsCorrect Answer

Organize an employee dataset by skills and experienceCorrect Answer

QUESTION 22 OF 25

A data professional at a finance company sorts spreadsheet data. They sort all data by ranking in the Financial Performance column, keeping together all data across rows. What spreadsheet tool are they using?

Sort Rows

Sort Together

Sort Column

Sort SheetCorrect Answer

QUESTION 23 OF 25

A data team investigates possible relationships in a dataset. What phase of analysis is the analyst in?

Get input from others

Organize data

Transform dataCorrect Answer

Format and adjust data

QUESTION 24 OF 25

Which query will return a list of all corn farms that have made more than $4 million, in order from the oldest to the newest business? FROM 'farms_directory' WHERE Crop = 'Corn', Revenue < 4000000 ORDER BY Years_in_business ASC FROM 'farms_directory' WHERE Crop = 'Corn' AND Revenue > 4000000 ORDER BY Years_in_business ASC FROM 'farms_directory' WHERE Crop = 'Corn' AND Revenue > 4000000 ORDER BY Years_in_business DSC FROM 'farms_directory' WHERE Crop = 'Corn' WHERE Revenue > 4000000 ORDER BY Years_in_business DSC

SELECT *Correct Answer

SELECTCorrect Answer

QUESTION 25 OF 25

A data professional in customer service is tasked with identifying customers who are at risk for taking their business to a competitor. In the analyze phase of the data analysis process, what activities might this involve? Select all that apply. 26 . Which function sorts a spreadsheet range between cells G1 and H60 in ascending order by the first column, Column G?

Prepare a report for the stakeholders

Request input from other customer service data professionalsCorrect Answer

Format the data to filter for low customer satisfaction scoresCorrect Answer

Organize a dataset by customer and purchase historyCorrect Answer

=SORT(G1:H60, 1, FALSE)

=SORT(G1:H60, A, FALSE)

=SORT(G1:H60, 1, TRUE)Correct Answer

=SORT(G1:H60, A, TRUE)

Ready to test your recall?

During which of the four phases of analysis can you find a correlation between two variables? Explanation : Finding a correlation between two variables occurs while transforming data.

Format and adjust data

Organize data

Transform data

Get input from others

How confident are you in this answer?