Module 3: Set Up Your Data Analytics Toolbox Answers (Part 2: Q16–30)
This is Part 2 of the Module 3 quiz answers for “Set Up Your Data Analytics Toolbox” from the Google Data Analytics Professional Certificate on Coursera.
Here, we’ll walk through questions 16 to 30 with detailed explanations to support your learning.
To find answers to the remaining questions, check out the full module breakdown below:
*Module 3 challenge*
Graded Quiz
16. Fill in the blank: A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the _____ stage of the data life
- analyze
- manage
- plan ✅
- capture
Explanation:
Planning includes determining what data is needed, how it will be handled, and by whom.
17. The destroy stage of the data life cycle might involve which of the following actions? Select all that apply.
- Storing data for future use
- Shredding paper files ✅
- Uploading data to the cloud
- Using data-erasure software ✅
Explanation:
The destroy phase ensures sensitive data is securely deleted.
18. During the capture stage of the data life cycle, a data analyst may use spreadsheets to aggregate data.
- True
- False ✅
Explanation:
Spreadsheets are generally used after data is captured—for processing or analyzing, not during capture.
19. Describe how the data life cycle differs from data analysis.
- The data life cycle deals with making informed decisions; data analysis is using tools to transform data.
- The data life cycle deals with transforming and verifying data; data analysis is using the insights gained from the data.
- The data life cycle deals with identifying the best data to solve a problem; data analysis is about asking effective questions.
- The data life cycle deals with the stages that data goes through during its useful life; data analysis is the process of analyzing data. ✅
Explanation:
The data life cycle involves stages data goes through, while data analysis is the actual examination and interpretation of data.
20. What actions might a data analytics team take in the act phase of the data analysis process? Select all that apply.
- Sharing analysis results using data visualizations
- Putting a plan into action to help solve the business problem ✅
- Validating insights provided by analysts ✅
- Finalizing a strategy based on the analysis ✅
Explanation:
The act phase is where decisions are implemented and insights applied
21. Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.
- a predefined operation ✅
- a question written by the user
- a particular value
- a computer programming language
Explanation:
A function is a predefined command in a spreadsheet or programming language that performs a specific operation, which can be used within formulas to perform calculations.
22. Fill in the blank: To request, retrieve, and update information in a database, data analysts use a ____.
- calculation
- dashboard
- query ✅
- formula
Explanation:
A query is a command to ask the database for specific information.
23. Structured query language (SQL) enables data analysts to communicate with a database.
- True ✅
- False
Explanation:
SQL is the universal language for working with databases—selecting, updating, deleting, etc.
24. You are in the plan stage of the data lifecycle for your current project. What action might you take during this stage?
- Decide what kind of data is needed. ✅
- Use a formula to perform calculations.
- Validate insights provided by analysts.
- Shred paper files.
Explanation:
This is the phase where you figure out your data goals, sources, and responsibilities.
25. A data analyst is working at a small tech startup. They’ve just completed an analysis project, which involved private company information about a new product launch. In order to keep the information safe, the analyst uses secure data-erasure software for the digital files and a shredder for the paper files. Which state of the data life cycle does this describe?
- Manage
- Archive
- Destroy
- Plan ✅
26. A data analyst is working at a small tech startup. On their current project they are in the analyze stage of the data life cycle. What might they do in this stage?
- Choose the format of their spreadsheet headings
- Determine who is responsible for managing the data
- Validate the insights provided by analysts
- Use a formula to perform calculations ✅
Explanation:
Analysts manipulate and interpret data using tools and formulas here.
27. Fill in the blank: Data analysis has six process steps whereas the data life cycle has six _____.
- data analytics tools
- steps
- stages ✅
- key questions
Explanation:
These are: Plan, Capture, Manage, Analyze, Share, Destroy.
28. What is the main difference between a formula and a function?
- A formula can be used multiple times in a spreadsheet; a function can only be used once.
- A formula begins with an equal sign (=); a function begins with an asterisk (*).
- A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process. ✅
- A formula is used to add or subtract; a function is used to multiply or divide.
Explanation:
A formula can contain one or more functions, but not the other way around.
29. What does a data analyst use to request information within a database?
- Calculation
- Dashboard
- Formula
- Query ✅
Explanation:
A data analyst uses a query to request and retrieve specific information from a database.
30. Why is SQL the most popular structured query language? Select all that apply.
- SQL allows data analysts to use spreadsheets
- SQL is the most secure database on the market
- SQL is easy to understand ✅
- SQL works with a wide variety of databases ✅
Explanation:
SQL’s syntax is straightforward, making it accessible to beginners and professionals alike.
Hope this helped! Use the buttons below to move to the previous or next part.