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

A
WHERE all_bev !! carbonated_bev
B
WHERE all_bev >< carbonated_bev
C
WHERE all_bev != carbonated_bevCorrect Answer
D
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.

A
increasing
B
decreasing
C
the sameCorrect Answer
D
null
QUESTION 3 OF 20

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

A
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.
B
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
C
The sum of any values in cells H1 to H50and cells J1 to J50 that are greater than or equal to 50.
D
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.

A
The calculated field in a pivot table is used to apply filters based on specific criteria.
B
The values in a pivot table are used to calculate and count data.Correct Answer
C
The rows of a pivot table organize and group data horizontally.Correct Answer
D
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?

A
=COUNTIF(G2:G30,BK09876)
B
=COUNTIF(G2:G30,“BK09876”)Correct Answer
C
=COUNTIF(G2:G30,“=BK09876”)
D
=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.

A
CREATE TABLE
B
WITH TEMP
C
DROP TABLE
D
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;

A
1 WITH new_table = (
B
1 CREATE TABLE new_table AS (
C
1WITH new_table AS (
D
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 )

A
1
B
3
C
6
D
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.

A
WHERE ocean_currents !! ocean_tides
B
WHERE ocean_currents >< ocean_tides
C
WHERE ocean_currents <> ocean_tidesCorrect Answer
D
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.

A
ORDER BY
B
TABLE
C
WITH
D
GROUP BYCorrect Answer
QUESTION 11 OF 20

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

A
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.
B
The count of the number of cells in the array E2:E10 that have a value greater than or equal to 50.
C
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
D
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?

A
=COUNTIF(C1:C100,“=turbine”)
B
=COUNTIF(C1:C100,“turbine”)Correct Answer
C
=COUNTIF(turbine=C1:C100)
D
=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.

A
table view
B
defined function
C
new tableCorrect Answer
D
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 );

A
1 SELECTCorrect Answer
B
1 CREATE TABLE my_table AS (
C
1 WITH my_table FROM (
D
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.

A
summary rowsCorrect Answer
B
new columns
C
an aggregate table
D
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.

A
CREATE TABLE
B
SELECT INTOCorrect Answer
C
DROP TABLE
D
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.

A
WHERE materials_sorter !! compost_sorter
B
WHERE materials_sorter >< compost_sorter
C
WHERE materials_sorter <> compost_sorterCorrect Answer
D
WHERE materials_sorter != compost_sorterCorrect Answer
QUESTION 18 OF 20

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

A
The sum of any values in cells K20 to K70 and cells L20 to L70 that are greater than or equal to 50.
B
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
C
The count of the number of cells in the array K20:K70 that have a value greater than or equal to 50.
D
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?

A
=COUNTIF(L10:L300,“>500”)
B
=COUNTIF(L10:L300,”<500”)Correct Answer
C
=COUNTIF(“>500”,L10:L300)
D
=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) );

A
1 WITH temp_table FROM (
B
1 SELECTCorrect Answer
C
1 CREATE TABLE temp_table AS (
D
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).
A
WHERE all_bev !! carbonated_bev
B
WHERE all_bev >< carbonated_bev
C
WHERE all_bev != carbonated_bev
D
WHERE all_bev <> carbonated_bev

How confident are you in this answer?