1) 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 cycle.
Ans: Plan
2) The destroy stage of the data life cycle might involve which of the following actions? Select all that apply.
Ans:
- Using data-erasure software
- Shredding paper files
3) A data analyst uses a spreadsheet function to aggregate data. Then, they add a pivot table to show totals from least to greatest. This would happen during which stage of the data life cycle?
Ans: Analyze
4) The data life cycle deals with the stages that data goes through; data analysis involves following a process to analyze data.
Ans: True
5) What actions might a data analytics team take in the act phase of the data analysis process? Select all that apply.
Ans:
- Validating insights provided by analysts
- Putting a plan into action to help solve the business problem
- Finalizing a strategy based on the analysis
6) What is the main difference between a formula and a function?
Ans: 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
7) Fill in the blank: A query is used to _____ information from a database. Select all that apply.
Ans:
8) Structured query language (SQL) enables data analysts to communicate with a database.
Ans: True
9) A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle?
Ans: destroy
10) Data analysts use queries to request, retrieve, and update information within a database.
Ans: True
11) Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____.
Ans: process steps
12) Fill in the blank: A function is a predefined operation, whereas a formula is _____.
Ans: a set of instructions used to perform a specified calculation.
13) Fill in the blank: To request, retrieve, and update information in a database, data analysts use a ____.
Ans: query
14) Fill in the blank: Structured query language (SQL) enables data analysts to _____ the information in a database. Select all that apply.
Ans:
8.Structured query language (SQL) enables data analysts to communicate with a database.
Post navigation7.Fill in the blank: A query is used to _____ information from a database. Select all that apply.
Post navigationLatest Submission Grade: 100% The manage stage of the data life cycle is when a business decides what kind of data it needs, how the data will be handled, and who will be responsible for it. During planning, a business decides what
kind of data it needs, how it will be managed throughout its life cycle, who will be responsible for it, and the optimal outcomes. A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle? This describes the destroy phase, during which data analysts use secure data-erasure software and shred paper files to protect private information. In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply. In the analyze phase of the data life cycle, a data analyst might use formulas to perform calculations, create a report from the data, or use spreadsheets to aggregate data. Describe how the data life cycle differs from data analysis. The
data life cycle involves stages for identifying needs and managing data. Data analysis involves process steps to make meaning from data.Weekly challenge 3
Question 1
Question 2
Question 3
Question 4
Question 5
A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process?
- Analyze
- Process
- Share
- Act
The act phase is when insights are put into action.
Question 6
Fill in the blank: Spreadsheets are _____ that can be used to store, organize, and sort data.
- digital worksheets
- formulas and functions
- interactive dashboards
- visual representations
Spreadsheets are digital worksheets that can be used to store, organize, and sort data.
Question 7
Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.
- a question written by the user
- a predefined operation
- a computer programming language
- a particular value
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.
Question 8
Fill in the blank: A query is used to _____ information from a database. Select all that apply.
- update
- request
- retrieve
- analyze
A query enables data analysts to request, retrieve, and update information from a database.
Question 9
Structured query language (SQL) enables data analysts to communicate with a database.
- True
- False
SQL allows a data analyst to communicate with a database in order to retrieve and manipulate data.
Question 10
The graphical representation of information helps stakeholders understand data insights. Formulas and functions make this possible.
- True
- False
The graphical representation of information is made possible by data visualization tools. These tools help stakeholders understand data insights.