🌍 All Study Guides 📊 Dashboard 📰 Blog 💡 About

Google Data Analytics Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 20

A data analyst at a beverage producer manually recalculates the new column carbonated_bev. They want to identify any rows with values that do not match those in the original column, all_bev. Which SQL clauses would enable them to do so? Select all that apply.

WHERE all_bev !! carbonated_bev

WHERE all_bev >< carbonated_bev

WHERE all_bev != carbonated_bevCorrect Answer

WHERE all_bev <> carbonated_bevCorrect Answer

QUESTION 2 OF 20

Fill in the blank: The SQL command GROUP BY groups table rows with _____ values into summary rows.

increasing

decreasing

the sameCorrect Answer

null

QUESTION 3 OF 20

What will this spreadsheet function return? =SUMIF(H1:H50, ”>=50”, J1:J50)

The sum of all values in cells H1 to H50 for which the value in cells J1 to J50 is greater than or equal to 50.

The sum of all values in cells J1 to J50 that correspond to values in cells H1 to H50 that are greater than or equal to 50.Correct Answer

The sum of any values in cells H1 to H50and cells J1 to J50 that are greater than or equal to 50.

The count of the number of cells in the array H1:H50 that have a value greater than or equal to 50.

QUESTION 4 OF 20

Which of the following statements accurately describe pivot tables? Select all that apply.

The calculated field in a pivot table is used to apply filters based on specific criteria.

The values in a pivot table are used to calculate and count data.Correct Answer

The rows of a pivot table organize and group data horizontally.Correct Answer

A pivot table is a data summarization tool.Correct Answer

QUESTION 5 OF 20

A data professional in the trucking industry calculates the number of spreadsheet rows that contain the SKU value BK09876. Which function do they use?

=COUNTIF(G2:G30,BK09876)

=COUNTIF(G2:G30,“BK09876”)Correct Answer

=COUNTIF(G2:G30,“=BK09876”)

=COUNTIF(BK09876=G2:G30)

QUESTION 6 OF 20

Fill in the blank: The _____ statement copies data from one table into a new table without adding the new table to the database.

CREATE TABLE

WITH TEMP

DROP TABLE

SELECT INTOCorrect Answer

QUESTION 7 OF 20

Which SQL statement will create a temporary table? 2 SELECT * 3 FROM old_table 4 ); 2 FROM old_table 3 ); 2 SELECT * 3 FROM old_table WHERE z = 5 (CORRECT) 4 ); 2 FROM old_table;

1 WITH new_table = (

1 CREATE TABLE new_table AS (

1WITH new_table AS (

1 SELECT new_table

QUESTION 8 OF 20

How many different columns have been added to the values section of the pivot table editor? ( Image S1Q8 )

2Correct Answer

QUESTION 9 OF 20

A data analyst at an ocean conservancy manually recalculates the new column ocean_currents. They want to identify any rows with values that do not match those in the original column, ocean_tides. Which SQL clauses would enable them to do so? Select all that apply.

WHERE ocean_currents !! ocean_tides

WHERE ocean_currents >< ocean_tides

WHERE ocean_currents <> ocean_tidesCorrect Answer

WHERE ocean_currents != ocean_tidesCorrect Answer

QUESTION 10 OF 20

Fill in the blank: The SQL command _____ combines table rows with the same values into summary rows.

ORDER BY

TABLE

WITH

GROUP BYCorrect Answer

QUESTION 11 OF 20

What will this spreadsheet function return? =SUMIF(E2:E10, ”>=50”, F2:F10)

The sum of all values in cells E2 to E10 for which the value in cells F2 to F10 is greater than or equal to 50.

The count of the number of cells in the array E2:E10 that have a value greater than or equal to 50.

The sum of all values in cells F2 to F10 that correspond to values in cells E2 to E10 that are greater than or equal to 50.Correct Answer

The sum of any values in cells E2 to E10 and cells F2 to F10 that are greater than or equal to 50.

QUESTION 12 OF 20

A data analyst at an engineering company calculates the number of spreadsheet rows that contain the value turbine. Which function do they use?

=COUNTIF(C1:C100,“=turbine”)

=COUNTIF(C1:C100,“turbine”)Correct Answer

=COUNTIF(turbine=C1:C100)

=COUNTIF(C1:C100,turbine)

QUESTION 13 OF 20

Fill in the blank: To copy data from one table into a _____, a data professional uses the SELECT INTO statement.

table view

defined function

new tableCorrect Answer

temporary table

QUESTION 14 OF 20

Which SQL statement will create a temporary table? 2 FROM table; 2 SELECT * 3 FROM other_table 4 ); 2 SELECT * 3 FROM other_table 4 ); 2 SELECT * 3 FROM other_table WHERE x = 0 4 );

1 SELECTCorrect Answer

1 CREATE TABLE my_table AS (

1 WITH my_table FROM (

1 WITH my_table AS (Correct Answer

QUESTION 15 OF 20

Fill in the blank: To group table rows with the same values into_____, a data analyst uses the SQL command GROUP BY.

summary rowsCorrect Answer

new columns

an aggregate table

a temporary table

QUESTION 16 OF 20

Fill in the blank: The _____ statement is useful for making a copy of a table with a specific condition without adding the new table to the database.

CREATE TABLE

SELECT INTOCorrect Answer

DROP TABLE

WITH TEMP

QUESTION 17 OF 20

A data analyst at a recycling company manually recalculates the new column materials_sorter. They want to identify any rows with values that do not match those in the original column, compost_sorter. Which SQL clauses would enable them to do so? Select all that apply.

WHERE materials_sorter !! compost_sorter

WHERE materials_sorter >< compost_sorter

WHERE materials_sorter <> compost_sorterCorrect Answer

WHERE materials_sorter != compost_sorterCorrect Answer

QUESTION 18 OF 20

What will this spreadsheet function return? =SUMIF(K20:K70, ”>=50”, L20:L70)

The sum of any values in cells K20 to K70 and cells L20 to L70 that are greater than or equal to 50.

The sum of all values in cells L20 to L70 that correspond to values in cells K20 to K70 that are greater than or equal to 50.Correct Answer

The count of the number of cells in the array K20:K70 that have a value greater than or equal to 50.

The sum of all values in cells K20 to K70 for which the value in cells L20 to L70 is greater than or equal to 50.

QUESTION 19 OF 20

A data analyst at a party planning business reviews attendee counts. They calculate the number of spreadsheet rows that contain values less than 500. Which function do they use?

=COUNTIF(L10:L300,“>500”)

=COUNTIF(L10:L300,”<500”)Correct Answer

=COUNTIF(“>500”,L10:L300)

=COUNTIF(”<500”,L10:L300)

QUESTION 20 OF 20

Which SQL statement will create a temporary table? 2 SELECT * 3 = orig_table 4 ); 2 FROM temp_table; 2 SELECT orig_table 3 ); 2 SELECT * 3 FROM orig_table WHERE y = 1 (CORRECT) );

1 WITH temp_table FROM (

1 SELECTCorrect Answer

1 CREATE TABLE temp_table AS (

1 WITH temp_table AS (

Ready to test your recall?

A data analyst at a beverage producer manually recalculates the new column carbonated_bev. They want to identify any rows with values that do not match those in the original column, all_bev. Which SQL clauses would enable them to do so? Select all that apply.

💡Select all 2 correct answers before submitting (0 of 2 selected).

WHERE all_bev !! carbonated_bev

WHERE all_bev >< carbonated_bev

WHERE all_bev != carbonated_bev

WHERE all_bev <> carbonated_bev

How confident are you in this answer?