Skip to content

Module 2 challenge :Foundations: Data, Data, Everywhere (Google Data Analytics Professional Certificate) Answers 2025

Question 1

Which of the following activities are part of the manage phase of the data life cycle?

✅ Select tools to keep data secure
✅ Decide where to store data
❌ Reflect on how to care for data
❌ Use the data to solve problems

Explanation:
The manage phase focuses on organizing, storing, and securing data — not solving or reflecting.


Question 2

Which spreadsheet feature uses a set of instructions to perform calculations, such as multiplication or division?

✅ Formula
❌ Function
❌ Filter
❌ Format

Explanation:
A formula performs calculations (like =A1*B1). Functions (like SUM() or AVERAGE()) are part of formulas.


Question 3

Which statements correctly describe the archive and destroy phases of the data life cycle?

✅ Archiving means storing data, although it may not be used again.
✅ A key reason for destroying data is to protect sensitive customer information.
✅ Shredders may be used to destroy data that is on paper.
❌ The best way to protect private data is to archive it for future use.

Explanation:
Archiving = long-term storage; destroying = secure deletion of unneeded or sensitive data.


Question 4

What tasks may occur during the ask step of the data analysis process?

✅ Determine whether something needs to be fixed
✅ Use the five whys
✅ Communicate with stakeholders
❌ Properly maintain a database

Explanation:
The ask step involves defining the problem, clarifying needs, and understanding context — not maintaining databases.


Question 5

Fill in the blank: During the prepare step of the data analysis process, data is _____ and stored for analysis.

✅ collected
❌ interpreted
❌ modified
❌ shared

Explanation:
The prepare step is all about collecting and organizing data from various sources.


Question 6

A timber company discusses what type of data they need and how it will be managed. What phase is this?

✅ Plan
❌ Manage
❌ Capture
❌ Archive

Explanation:
The plan phase defines what data is needed, how it’s collected, and managed — setting the project’s foundation.


Question 7

A data professional fixes typos and inaccuracies, then verifies and shares cleaning procedures.

✅ Process
❌ Prepare
❌ Ask
❌ Analyze

Explanation:
The process step is where data is cleaned, verified, and made ready for analysis.


Question 8

During the _____ step of the data analysis process, data analysts use tools such as spreadsheets to draw useful conclusions.

✅ analyze
❌ act
❌ process
❌ share

Explanation:
The analyze step is about applying tools and logic to extract insights and find patterns.


Question 9

What are some key benefits of data visualizations?

✅ Complex data can be shared more effectively with nontechnical audiences.
✅ Data visualizations help people gain insights from data more quickly.
✅ Maps help people identify patterns in data.
❌ Data visualizations do not require labels or descriptions.

Explanation:
Visualizations simplify complex data but still need labels and explanations to be understood clearly.


Question 10

A university gathers data from multiple sources. This occurs during the _____ phase of the data life cycle.

✅ capture
❌ analyze
❌ manage
❌ plan

Explanation:
The capture phase involves collecting and bringing in data from various sources into the system.


🧾 Summary Table

Q# ✅ Correct Answer(s) Key Concept
1 Select tools to keep data secure; Decide where to store data Managing & securing data
2 Formula Spreadsheet calculations
3 2, 3, 4 ✅ Archiving vs destroying data
4 1, 2, 3 ✅ Asking key questions
5 collected Data gathering
6 Plan Planning phase
7 Process Data cleaning
8 analyze Drawing insights
9 1, 2, 3 ✅ Benefits of visualization
10 capture Data collection phase