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

A
Format and adjust data
B
Organize data
C
Transform dataCorrect Answer
D
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.

A
True
B
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?

A
=SORT(F19:G82, 2, FALSE)
B
=SORT(F19:G82, B, TRUE)
C
=SORT(F19:G82, 2, TRUE)Correct Answer
D
=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?

A
AnalyzeCorrect Answer
B
Process
C
Act
D
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.

A
Recognize relationships in your dataCorrect Answer
B
Eliminate irrelevant info from your data
C
Make calculations based on your dataCorrect Answer
D
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.

A
model
B
calculation
C
observation
D
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?

A
Sort SheetCorrect Answer
B
Sort Together
C
Sort Document
D
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?

A
So What
B
Summertime
C
Compulsion
D
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?

A
Sort Rows
B
Sort Column
C
Sort Together
D
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.

A
LIMIT
B
EXCEPT
C
FILTER
D
WHERECorrect Answer
QUESTION 11 OF 25

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

A
Get input from others
B
Format and adjust data
C
Organize data
D
Transform dataCorrect Answer
QUESTION 12 OF 25

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

A
Filtering can be performed in spreadsheets, but not SQL databases.
B
Filtering enables data professionals to view the data that is most important.Correct Answer
C
Sorting involves arranging data into a meaningful order.Correct Answer
D
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.

A
formatting and adjusting dataCorrect Answer
B
organizing data
C
getting input from others
D
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)

A
1 SELECTCorrect Answer
B
1 SELECTCorrect Answer
C
1 SELECTCorrect Answer
D
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.

A
Prepare a report for the stakeholders
B
Organize a dataset by machine type and performance levelsCorrect Answer
C
Get input from colleagues on the data teamCorrect Answer
D
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?

A
=SORT(K1:L80, A, TRUE)
B
=SORT(K1:L80, A, FALSE)
C
=SORT(K1:L80, 1, TRUE)Correct Answer
D
=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?

A
Format and adjust data
B
Organize data
C
Transform dataCorrect Answer
D
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?

A
=SORT(C1:D70, A, TRUE)
B
=SORT(C1:D70, 1, FALSE)
C
=SORT(C1:D70, 1, TRUE)Correct Answer
D
=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.

A
Sort Document
B
Sort SheetCorrect Answer
C
Sort Together
D
Sort Rank
A
LIMIT
B
FILTER
C
EXCEPT
D
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.

A
transforming data
B
formatting and adjusting data
C
getting input from othersCorrect Answer
D
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.

A
Prepare a report for the stakeholders
B
Get input from other HR data professionalsCorrect Answer
C
Format the data to filter for keywords relevant to the upcoming projectsCorrect Answer
D
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?

A
Sort Rows
B
Sort Together
C
Sort Column
D
Sort SheetCorrect Answer
QUESTION 23 OF 25

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

A
Get input from others
B
Organize data
C
Transform dataCorrect Answer
D
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

A
SELECT *Correct Answer
B
SELECTCorrect Answer
C
SELECTCorrect Answer
D
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?

A
Prepare a report for the stakeholders
B
Request input from other customer service data professionalsCorrect Answer
C
Format the data to filter for low customer satisfaction scoresCorrect Answer
D
Organize a dataset by customer and purchase historyCorrect Answer
A
=SORT(G1:H60, 1, FALSE)
B
=SORT(G1:H60, A, FALSE)
C
=SORT(G1:H60, 1, TRUE)Correct Answer
D
=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.

A
Format and adjust data
B
Organize data
C
Transform data
D
Get input from others

How confident are you in this answer?