11. 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
12. Fill in the blank: Data analysis has six process steps whereas the data life cycle has six _____.
- data analytics tools
- steps
- stages
- key questions
13. 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.
14. What does a data analyst use to request information within a database?
- Calculation
- Dashboard
- Formula
- Query
15. 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
16. A data analyst uses spreadsheets to aggregate data during the capture phase of the data life cycle.
- True
- False
17. Fill in the blank: The data life cycle has six _____ .
- data analytics tools
- process steps
- key questions
- stages
18. Fill in the blank: A query is used to _____ information from a database. Select all that apply.
- request
- retrieve
- visualize
- update
Shuffle Q/A 2
19. Structured query language (SQL) allows a data analyst to retrieve and request data from a database. What else is SQL used for?
- Visualizing data within a database
- The revising phase of the data life cycle
- Updating databases
- The sharing phase of the data life cycle
20. Fill in the blank: A business is determining who should be responsible for the data in their current data analysis project. This means that the company is in the ______ stage of the data life cycle.
- manage
- plan
- analyze
- capture