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 |