Skip to content

Module 4 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025

Question 1

Identify rows where carbonated_bev values don’t match all_bev.

✅ WHERE all_bev <> carbonated_bev
✅ WHERE all_bev != carbonated_bev
❌ WHERE all_bev >< carbonated_bev
❌ WHERE all_bev !! carbonated_bev

Explanation:
In SQL, <> and != both mean “not equal to”.
Example:

SELECT *
FROM beverages
WHERE all_bev <> carbonated_bev;

Question 2

Fill in the blank: GROUP BY groups rows with same values into _____.

✅ summary rows
❌ new columns
❌ an aggregate table
❌ a temporary table

Explanation:
GROUP BY combines rows sharing the same value into summary rows, which can then be aggregated (SUM, COUNT, AVG, etc.).

Question 3

What will this function return?

=SUMIF(K20:K70, ">=50", L20:L70)

✅ The sum of all values in L20:L70 that correspond to K20:K70 values ≥ 50.
❌ Others

Explanation:
SUMIF(range, criteria, sum_range)
Here:

  • range = K20:K70 (criteria checked here)

  • criteria = “>=50”

  • sum_range = L20:L70 (values to be summed)

Question 4

Which statements describe pivot tables accurately?

✅ The filters section of a pivot table is used to apply filters based on specific criteria.
✅ A pivot table can be used to sort, reorganize, or group data.
❌ Columns organize values vertically.
❌ Rows organize vertically (rows are horizontal).

Explanation:
Pivot tables let you summarize, filter, and group data dynamically — filters limit what’s displayed, and rows/columns define layout.

Question 5

Count how many cells in G2:G30 contain “BK09876”.

✅ =COUNTIF(G2:G30,”BK09876″)
❌ =COUNTIF(BK09876=G2:G30)
❌ =COUNTIF(G2:G30,BK09876)
❌ =COUNTIF(G2:G30,”cell=BK09876″)

Explanation:
COUNTIF(range, criteria) counts how many cells meet a condition.
Example:

=COUNTIF(G2:G30,"BK09876")

Question 6

Which statement about creating temporary tables is TRUE?

✅ The exact syntax and availability of commands differ by RDBMS.
❌ WITH is always used
❌ Choice depends only on row count
❌ Identical SQL works across all DBMS

Explanation:
Different database systems (e.g., MySQL, PostgreSQL, SQL Server) have slight syntax differences for creating temporary or CTE tables.

Question 7

Which SQL statement will create a temporary table?

✅

WITH temp_table AS (
SELECT *
FROM orig_table
WHERE y = 1
);

❌ Others

Explanation:
WITH ... AS (...) creates a Common Table Expression (CTE) — a temporary result set available only during that query execution.

Question 8

Which column was set as a “Row” in the pivot table?

✅ day
❌ total_bill
❌ tip
❌ AVERAGE

Explanation:
Rows in the pivot table (Thursday, Friday, Saturday, Sunday) clearly come from the “day” column.

🧾 Summary Table

Q# ✅ Correct Answer(s) Key Concept
1 WHERE all_bev <> carbonated_bev, WHERE all_bev != carbonated_bev SQL inequality check
2 summary rows GROUP BY groups identical values
3 SUMIF(K20:K70,”>=50″,L20:L70) sums matching L values Conditional summation
4 1 & 2 ✅ Pivot table functions
5 =COUNTIF(G2:G30,”BK09876″) Conditional counting
6 Syntax differs by RDBMS SQL system differences
7 WITH temp_table AS (…) Create CTE
8 day Pivot table row label