1.3.4.Weekly challenge 3 - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

1st

LATEST SUBMISSION GRADE 87.5%

Question 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.

capture
analyze
plan
manage

Correct. A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the plan stage of the data life cycle.

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?

Plan
Manage
Archive
Destroy

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

Question 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?

0 / 1 point

~~Manage~~
Plan
Capture
Analyze

Incorrect. Review the section on the data life cycle for a refresher.

Question 4

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 the stages that data goes through during its useful life; data analysis is the process of analyzing 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 transforming and verifying data; data analysis is using the insights gained from the data.

Correct. 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 the share step of the data analysis process.

True
False

Correct. This describes the act phase, when insights are put into action.

Question 6

What is the main difference between a formula and a function?

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.
A formula begins with an equal sign (=); a function begins with an asterisk (*).
A formula can be used multiple times in a spreadsheet; a function can only be used once.

Correct. 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 7

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

True
False

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

Question 8

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

True
False

Correct. SQL allows a data analyst to communicate with a database in order to retrieve and manipulate data.

2nd

LATEST SUBMISSION GRADE 100%

Question 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.

manage
plan
capture
analyze

Correct. A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the plan stage of the data life cycle.

Question 2

The destroy stage of the data life cycle might involve which of the following actions? Select all that apply.

Uploading data to the cloud
Using data-erasure software
Shredding paper files

Correct. The destroy phase of the data life cycle might involve shredding paper files or using data-erasure software.

Storing data for future use

Question 3

During the capture stage of the data life cycle, a data analyst may use spreadsheets to aggregate data.

True
False

Correct. Using spreadsheets to aggregate data would happen during the analyze stage.

Question 4

Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____.

data analytics tools
data types
key questions
process steps

Correct. Although both the data life cycle and the data analysis process have six elements, the life cycle involves stages and analysis involves process steps.

Question 5

What actions might a data analytics team take in the act phase of the data analysis process? Select all that apply.

Finalizing a strategy based on the analysis
Putting a plan into action to help solve the business problem
~~Sharing analysis results using data visualizations~~
Validating insights provided by analysts

Correct. During the act phase, a data analytics team might validate insights, finalize a strategy, and put a plan into action.

Question 6

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 particular value
a question written by the user
a computer programming language