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