Module 3 challenge:Prepare Data for Exploration (Google Data Analytics Professional Certificate) Answers 2025

Question 1

Fill in the blank: Data professionals use data _____ to handle issues related to internal and external data flows while ensuring data assets are formally managed.

✅ Governance
❌ Strategy
❌ Integrity
❌ Mapping

Explanation:
Data governance is the framework of rules, roles, and processes that ensures data is properly managed, accurate, consistent, and secure across the organization.

---

Question 2

In the context of data analytics, what is the primary purpose of metadata?

✅ To provide context and information about the data, such as its structure, origin, definition, and characteristics.
❌ To perform calculations
❌ To store the individual records
❌ To define access protocols

Explanation:
Metadata = “data about data.” It describes things like file type, source, date created, owner, and purpose — helping analysts understand and manage the data.

---

Question 3

Which statements describe primary and foreign keys accurately?

✅ Primary keys are unique.
✅ A foreign key is a field within a table that is a primary key in another table.
✅ A table can have multiple foreign keys.
❌ A foreign key uniquely identifies a record in the table in which it is located.

Explanation:

• Primary key: uniquely identifies records within its table.

• Foreign key: links one table to another by referencing that table’s primary key.

• One table can have multiple foreign keys for multiple relationships.

---

Question 4

A data analyst runs:

✅ All fields of orders from customers in Finland
❌ All fields of customers
❌ Outside Finland
❌ Names only

Explanation:
SELECT * retrieves all columns, and WHERE Country = 'Finland' filters rows where the country matches Finland.

---

Question 5

Benefits of using external data for analysis:

✅ External data provides industry-level perspectives.
✅ External data, when validated and trusted, provides more data points and helps identify broad insights.
❌ External data is very reliable and pre-cleaned.
❌ External data is always open and free.

Explanation:
External data enriches internal data by providing broader context and comparative insights, though it must always be validated for reliability.

---

Question 6

The zoo wants to email donors who give ≥ $25. What spreadsheet tool helps?

✅ Filter the data to show only donors who have given more than $25 each year
❌ Sort ascending/descending
❌ Filter for less than $25

Explanation:
A filter narrows down spreadsheet data to meet specific conditions (e.g., donation amount ≥ $25).

---

Question 7

They want to view the order_date field:

✅

❌ Other options

Explanation:
The SELECT clause specifies the column to retrieve, and FROM specifies the table. The WHERE clause is unnecessary unless filtering.

---

Question 8

Return only green cars from the Color column:

✅

❌ Others

Explanation:
WHERE Color = 'Green' filters the table Cars to show only rows where the color is Green.

---

Question 9

What data initiative improves public planning and innovation?

✅ Open data initiatives
❌ Data governance
❌ Internal data
❌ Data privacy

Explanation:
Open data initiatives make data freely available to the public — enabling transparency, research, and innovation.

---

Question 10

Primary keys in the database tables:

✅ customer_id and services_id
❌ first_name and service_name
❌ first_name and service_id
❌ last_name and description

Explanation:
Primary keys uniquely identify each record in a table.

• customer_id uniquely identifies each customer.

• services_id uniquely identifies each service.

---

🧾 Summary Table

---