Data analysts use queries to request, retrieve, and update information within a database.

8.Structured query language (SQL) enables data analysts to communicate with a database.

7.Fill in the blank: A query is used to _____ information from a database. Select all that apply.

Weekly challenge 3

Latest Submission Grade: 100%

Question 1

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.

• True
• False

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.

Question 2

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?

• Manage
• Destroy
• Plan
• Archive

This describes the destroy phase, during which data analysts use secure data-erasure software and shred paper files to protect private information.

Question 3

In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.

• Use a formula to perform calculations
• Use spreadsheets to aggregate data
• Create a report from the data
• Choose the format of spreadsheet headings

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.

Question 4

Describe how the data life cycle differs from data analysis.

• 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 the stages that data goes through during its useful life; data analysis is the process of analyzing data.
• The data life cycle deals with making informed decisions; data analysis is using tools to transform 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 involves stages for identifying needs and managing data. Data analysis involves process steps to make meaning from data.

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.