2. Coursera - Google Data Analytics Pro - Module 1.2

What is a key difference between a formula and a function? A formula is a set of instructions, whereas a function is a preset command. A formula is a more efficient way of executing a task than a function. A formula is a preset command, whereas a function is a set of instructions. A formula automatically performs a process or task, whereas a function requires the user to type directions in order for it to execute.

A formula is a set of instructions, whereas a function is a preset command.

A junior data analyst is assigned a new project. They define the problem that they need to help solve and confirm they understand expectations. Which step of the data analysis process are they working in? Analyze Share Prepare Ask

Ask

Which tool in the data analysts toolbox is most likely to involve the creation of graphs, maps, or charts? Spreadsheet Database SQL Data visualization

Data visualization

What is the term for the computer system in which organizations store their data? Cache Database Data ecosystem Catalog

Database

Which of the following activities are part of the manage phase of the data life cycle? Select all that apply. Decide where to store data Use the data solve problems Reflect on how to care for data Select tools to keep data secure

Decide where to store data Reflect on how to care for data Select tools to keep data secure

Which of the following activities are part of the manage phase of the data life cycle? Select all that apply. Determine how to best maintain data Apply data insights to make effective business decisions Decide where to store data Think about what kinds of tools can be used to keep data safe

Decide where to store data Think about what kinds of tools can be used to keep data safe

What tasks may occur during the ask step of the data analysis process? Select all that apply. Define the problem to be solved Stay engaged by having a dialogue with stakeholders Consider the current state compared to the ideal state Select appropriate tools for cleaning the data

Define the problem to be solved Stay engaged by having a dialogue with stakeholders Consider the current state compared to the ideal state

Which of the following statements correctly describe the archive and the destroy phases of the data life cycle? Select all that apply. The destroy phase ensures data can be accessed again if necessary. Even if data might be needed again in the future, it still may be archived. Data that is no longer relevant to business goals is often archived. Data-erasure software can be used to destroy data on a hard drive.

Even if data might be needed again in the future, it still may be archived. Data-erasure software can be used to destroy data on a hard drive.

Which spreadsheet feature uses a set of instructions to perform calculations, such as multiplication or division? Formula Format Filter Function

Formula

What are some key benefits of data visualizations? Select all that apply. Graphs and charts help people understand complex data. Visuals enable data professionals to more effectively share insights with others. Data visualizations are more engaging than tables and numbers. Visualizing data ensures findings are unbiased.

Graphs and charts help people understand complex data. Visuals enable data professionals to more effectively share insights with others. Data visualizations are more engaging than tables and numbers.

What tasks may occur during the ask step of the data analysis process? Select all that apply. Conduct gap analysis Identify any obstacles Bring data into the organization Make sure expectations are clear

Identify any obstacles Make sure expectations are clear

A data professional at a beauty products enterprise is assigned a task related to customer buying habits. They think about what type of data they need to be successful, as well as optimal project outcomes. What phase of the data life cycle does this scenario describe? Plan Manage Archive Analyze

Plan

There are six phases in the data life cycle, which culminate with analyze, archive, and destroy. What is the correct order of the first three phases? Manage, capture, plan Plan, capture, manage Manage, plan, capture Plan, manage, capture

Plan, capture, manage

Which step of the data analysis process is most likely to involve creating visuals that help people understand complex facts and figures? Prepare Ask Share Act

Share

Which of the following statements correctly describe the archive and the destroy phases of the data life cycle? Select all that apply. The archive phase involves storing data. Even if data is no longer relevant to business goals, it should never be archived. Shredders may be used to destroy data on paper. A key reason for destroying data is to protect private company information.

Shredders may be used to destroy data on paper. A key reason for destroying data is to protect private company information.

What is the term for a digital worksheet that data analysts use to store, organize, and sort data? Report Spreadsheet Document Application

Spreadsheet

What is the term for people who invest time and resources into a project and are interested in the outcome? Data analysts Stakeholders Data designers Subject-matter experts

Stakeholders

What does SQL stand for? Systematic quality level Searchable question lingo Software quotient listing Structured query language

Structured query language

Fill in the blank: During the _____ step of the data analysis process, data analysts use tools such as spreadsheets to draw useful conclusions. share act process analyze

analyze

Fill in the blank: During the _____ step of the data analysis process, data team members use tools such as SQL to make predictions. act analyze share process

analyze

Fill in the blank: A high-tech manufacturer acquires data from an outside consumer tech association database and its own documentation about product features and pricing. This work occurs during the _____ phase of the data life cycle. analyze capture manage destroy

capture

Fill in the blank: A university system gathers historical academic data from an outside database and information from the internal records of student applications. This work occurs during the _____ phase of the data life cycle. plan analyze manage capture

capture

Fill in the blank: Data is _____ during the prepare step of the data analysis process. presented and shared analyzed and interpreted filtered and sorted collected and stored

collected and stored

Fill in the blank: In the process step, data analysts may remove _____, which are data points that lie significantly outside the overall pattern of the data and could potentially skew the information. outliers statistics values observations

outliers

Fill in the blank: During the _____ phase, data teams decide what kind of data is needed and who will be responsible for it. planning capture analyze manage

planning