Foundations: Data, Data, Everywhere Quiz Answers – 100% Correct Answers

Get All Weeks Foundations: Data, Data, Everywhere Quiz Answers

Foundations: Data, Data, Everywhere Week 1 Quiz Answers

Practice Quiz-1 Answers

L3 Understanding the data ecosystem:

Q1. Which of the following statements best defines data?

• Data is an assortment of questions.
• Data is a business process.
• Data is a collection of facts.
• Data is the use of calculations and statistics.

Q2. Fill in the blank: In data analytics, the data ecosystem refers to the various elements that interact with one another to produce, manage, store, _____, analyze, and share data.

• organize
• ingest
• merge
• locate

Q3. Which of the following terms refers to the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making?

• Data life cycle
• Data insight
• Data elements
• Data analysis

Q4. An airline collects, observes, and analyzes its customers’ online behaviors. Then, it uses the insights gained to choose what new products and services to offer. What business process does this describe?

• Analytical thinking
• Performance measurement
• Collaboration with stakeholders
• Data-driven decision-making

Foundations: Data, Data, Everywhere Weekly Challenge 1 Answers

Q1. Which of the following options describes data analysis?

• Creating new ways of modeling and understanding the unknown by using raw data
• The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making
• The various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data
• Using facts to guide business strategy

Q2. A business collects and analyzes information about its employees in order to gain insights that unlock potential and create a more productive workplace. What practice does this describe?

• Workforce observation
• Employee retention
• Team collaboration
• People analytics

Q3. In data analytics, a model is a group of elements that interact with one another.

• True
• False

Q4. Fill in the blank: The term _____ is defined as an intuitive understanding of something with little or no explanation.

• awareness
• personal opinion
• rational thought
• gut instinct

Q5. A company defines a problem it wants to solve. Then, a data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst shares their analysis with subject-matter experts, who validate the findings. Finally, a plan is put into action. What does this scenario describe?

• Identification of trends
• Data-driven decision-making
• Customer service
• Data science

Q6. Fill in the blank: The people very familiar with a business problem are called _____. They are an important part of data-driven decision-making.

• subject-matter experts
• stakeholders
• competitors
• customers

Q7. A data analyst finishes analyzing data for a marketing project. The results are clear, so they present findings to the client and ask for conclusions and recommendations. What should they have done first?

• Archived the datasets in order to keep them secure
• Created a model based on the results of the analysis
• Shared the results with subject-matter experts from the marketing team for their input
• Surveyed customers about results, conclusions, and recommendations

Q8. You have recently subscribed to an online data analytics magazine. You really enjoyed an article and want to share it in the discussion forum. Which of the following would be appropriate in a post? Select all that apply.

• Including an advertisement for how to subscribe to the data analytics magazine
• Checking your post for typos or grammatical errors
• Giving credit to the original author
• Including your own thoughts about the article

Foundations: Data, Data, Everywhere Week 2 Quiz Answers

Practice Quiz-1 Answers

L2 Embracing data analyst skills:

Q1. Identify the pattern from left to right in the set of blocks below and try to predict which block should replace the block with the question mark.

Answer:

Q2. Here’s a more complex pattern. Identify the pattern from left to right in the images below and try to predict which image should come next. A series of different boxes containing shapes and patterns with the last box containing a question mark

Based on the images above, which option comes next in the pattern?

Answer:

Q3. Now, find a pattern in a different format. Select the next number in the sequence:

Fill in the blank: 9, 13, 17, 21, 25, 29, _____

• 10
• 55
• 33
• 25

Q4. The following numbers are in a sequence from left to right. Determine the pattern and decide which number should come next:

Fill in the blank: 4, 9, 16, 25, 36, 49, _____

• 81
• 62
• 30
• 64

Q5. The following question is about recognizing and matching patterns in shapes that are the same, but viewed from different angles.

Two shapes are similar when one can become the other after a rotation clockwise ⟳ or counterclockwise ↺, or a reflection horizontally ↔ and/or vertically ↕. Top right, bottom left is to top left, bottom right

Your task is to choose the figure that completes the statement. Pay attention to the pattern by which the first and second shapes are related, and then figure out which choice matches shape 3. Fill in the blank: Top: left & center, middle: right IS TO top: right & center, middle: left AS top: right, middle: center, bottom: left IS TO

Select the image below that completes the statement.

Answer:

Q6. The following question is about recognizing and matching patterns in shapes that are the same, but viewed from different angles. Two shapes are similar when one can become the other after a rotation clockwise ⟳ or counterclockwise ↺, or a reflection horizontally ↔ and/or vertically ↕.

Your task is to choose the figure that completes the statement. Fill in the blank:

Which image completes it?

Answer:

Q7. The following series of codes are in a sequence from left to right. There is a repeating pattern that you will notice. Determine the pattern and decide which code should come next.

Fill in the blank: A1, B3, C5, D7, E9, F11, G13, _____

• J15
• H16
• D17
• H15

Q8. The following series of codes are in a sequence from left to right. There is a repeating pattern that you will notice. Determine the pattern and decide which sequence of letters should come next.

Fill in the blank: A, AA, AAA, B, BA, BAA, BAAA, BB, BBA, BBAA, BBAAA, BBB, ________

• BBBA
• BBBB
• BBAA
• BBAAA

Q9. Now, identify patterns in a word problem using a data visualization. There are 12 chocolates in a box: eight have caramel filling, six have coconut filling, and two have both caramel and coconut filling. Choose the best image that describes this box of chocolates.

Answer:

Q10. There are 10 children in a class and they have all brought sandwiches for lunch: five children have sandwiches with peanut butter, six children have sandwiches with jelly, and three children have sandwiches with both peanut butter and jelly.

Find out how many children have sandwiches with neither peanut butter nor jelly and choose the image that describes the situation best.

Answer:

Practice Quiz-2 Answers

L3 Thinking about analytical thinking:

Q1. What practice involves identifying, defining, and solving a problem by using data in an organized, step-by-step manner?

• Context
• Data design
• Analytical thinking
• Visualization

Q2. Data visualization is the graphical representation of information, including which of the following? Select all that apply.

• Icons
• Maps
• Charts
• Graphs

Q3. Gap analysis is used to examine and evaluate how a process currently works with the goal of getting to where you want to be in the future.

• True
• False

Practice Quiz-3 Answers

L4 Thinking about outcomes:

Q1. Fill in the blank: Curiosity, understanding context, and having a technical mindset are all examples of _____ used in data-driven decision-making.

• analytical skills
• business strategies
• thought processes
• data models

Q2. Surveying customers about their preferences and using that information to inform business strategy is an example of data-driven decision-making.

• True
• False

Q3. In data analysis, which analytical skill involves the management of people, processes, and tools?

• Data control
• Data strategy
• Data analytics
• Data design

Foundations: Data, Data, Everywhere Weekly Challenge 2 Answers

Q1. Fill in the blank: Analytical skills are defined as _____.

• qualities and characteristics associated with solving problems using facts
• an analyst’s intuition, inner voice, or gut instinct
• the management of people, processes, and tools
• the ability to break things down into smaller steps

Q2. A junior data analyst is seeking out new experiences in order to gain knowledge. They watch videos and read articles about data analytics. They ask experts questions. Which analytical skill are they using?

• Understanding context
• Curiosity
• Data strategy
• Having a technical mindset

Q3. Identifying the motivation behind data collection and gathering additional information are examples of which analytical skill?

• Data design
• Understanding context
• Data strategy
• A technical mindset

Q4. Having a technical mindset is an analytical skill involving what?

• Managing people, processes, and tools
• Breaking things down into smaller steps or pieces
• Understanding the condition in which something exists or happens
• Balancing roles and responsibilities

Q5. Which analytical skill involves managing the people, processes, and tools used in data analysis?

• Curiosity
• Understanding context
• Data strategy
• Data design

Q6. Correlation is the aspect of analytical thinking that involves figuring out the specifics that help you execute a plan.

• True
• False

Q7. Fill in the blank: Detail-oriented thinking is about figuring out all of the _____ that will help you execute a plan.

• specifics
• datasets
• instructions
• information

Q8. The five whys is a technique that involves asking, “Why?” five times in order to achieve what goal?

• Identify the root cause of a problem
• Visualize how a process should look in the future
• Use facts to guide business strategy
• Put a plan into action

Q9. What method involves examining and evaluating how a process works currently in order to get it where you want it to be in the future?

• Gap analysis
• The five whys
• Strategy
• Data visualization

Q10. Data-driven decision-making involves the five analytical skills: curiosity, understanding context, having a technical mindset, data design, and data strategy. Each plays a role in data-driven decision-making.

• True
• False

Foundations: Data, Data, Everywhere Week 3 Quiz Answers

Practice Quiz-1 Answers

L2 Following the data life cycle:

Q1. Fill in the blank: During the _____ phase of the data life cycle, a business decides what kind of data it needs, how it will be managed, who will be responsible for it, and the optimal outcomes.

• archive
• planning
• manage
• capture

Q2. In the data life cycle, which phase involves gathering data from various sources and bringing it into the organization?

• Manage
• Analyze
• Archive
• Capture

Q3. A data analyst finishes using a dataset, so they erase or shred the files in order to protect private information. This is called archiving.

• True
• False

Q4. A dairy farmer decides to open an ice cream shop on her farm. After surveying the local community about people’s favorite flavors, she takes the data they provided and stores it in a secure hard drive so it can be maintained safely on her computer. This is part of which phase of the data life cycle?

• Manage
• Plan
• Analyze
• Archive

Q5. After opening the ice cream shop on her farm, the dairy farmer surveys the local community about people’s favorite flavors. She uses the data she collected to determine that the top five flavors are strawberry, vanilla, chocolate, mint chip, and peanut butter. She feels confident in her decision to sell these flavors. This is part of which phase of the data life cycle?

• Capture
• Plan
• Analyze
• Archive

Practice Quiz-2 Answers

L3 Outlining the data analysis process:

Q1. The data analysis process phases are ask, prepare, process, analyze, share, and act. What do data analysts do during the ask phase?

• Clean the data
• Define the problem to be solved
• Collect and store data
• Create data visualizations.

Q2. The data analysis process phases are ask, prepare, process, analyze, share, and act. A data analyst cleans data to ensure it’s complete and correct during the process phase.

• True
• False

Q3. The data analysis process steps are ask, prepare, process, analyze, share, and act. During which phase would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions?

• Act
• Analyze
• Process
• Prepare

Q4. The data analysis process steps are ask, prepare, process, analyze, share, and act. In which step would a data analyst use visuals such as charts or graphs to simplify complex data for better understanding?

• Process
• Share
• Act
• Prepare

Q5. A data analyst shares insights from their analysis during a formal presentation. In a slideshow, they make a data-driven recommendation for how to solve a business problem. What step of the data analysis process would come next?

• Act
• Prepare
• Ask
• Process

Practice Quiz-3 Answers

L4 The data analysis toolbox:

Q1. A spreadsheet is a digital worksheet that enables data analysts to do which of the following tasks? Select all that apply.

• Store data
• Organize data in columns and rows
• Sort and filter data
• Automatically access the latest data in real-time

Q2. Fill in the blank: A set of instructions that performs a specific calculation using spreadsheet data is called _____.

• a program
• a function
• an operation
• a formula

Q3. A database is a collection of data stored in a computer system.

• True
• False

Q4. In data analytics, SQL is an acronym meaning _____ query language.

• structured
• syntax
• software
• statistical

Q5. What is the term for the graphical representation of data?

• Data visualization
• Data summary
• Data language
• Data collection

Foundations: Data, Data, Everywhere Weekly Challenge 3 Answers

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

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

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

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

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

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

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

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

• update
• request
• retrieve
• analyze

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

• True
• False

Q10. The graphical representation of information helps stakeholders understand data insights. Formulas and functions make this possible.

• True
• False

Foundations: Data, Data, Everywhere Week 4 Quiz Answers

Practice Quiz-1 Answers

L2 Mastering spreadsheet basics:

Q1. In a spreadsheet, what is text wrapping used for?

• To allow text to overflow into an adjacent cell
• To automatically change cell height in order to allow all of the text to fit inside
• To remove text that is too long to fit in a cell
• To clip text within a cell so it doesn’t overflow into an adjacent cell

Q2. The columns in a spreadsheet are ordered by letter, and the rows are ordered by number.

• True
• False

Q3. Fill in the blank: In a dataset, a row is called an observation. An observation includes all of the _____ for something contained in the row.

• names
• commonalities
• attributes
• diagnostics

Practice Quiz-2 Answers

L3 Learn about Structured Query Language (SQL):

Q1.

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

What does the asterisk (*) after SELECT tell the database to do in this query?

• Select, then delete data.
• Select and filter data.
• Select and multiply data.
• Select all data.

Q2.

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

In this query, the data analyst wants to retrieve data from which table?

• LastName
• employee
• James
• jobCode

Q3.

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

In this query, the data analyst wants to retrieve all data from the employee table, where the jobCode is FTE and the last name is James.

• True
• False

Q4. You are writing a query and want to instruct the database to retrieve data from the warehouse_inventory table. What is the SQL statement that follows SELECT *? Type your answer below.

FROM warehouse_inventory

Practice Quiz-3 Answers

L4 Visualizing the data:

Q1. Fill in the blank: A data visualization is the _____ representation of information.

• contextual
• tabulated
• graphical
• attributed

Q2. A data analyst uses data visualizations to support their findings.

• True
• False

Q3. A data analyst is creating a data visualization to share with stakeholders. Which spreadsheet tool do they use to select different chart types?

• Chart Editor
• Chart Maker
• Chart Picker
• Chart Chooser

Foundations: Data, Data, Everywhere Weekly Challenge 4 Answers

Q1. In the following spreadsheet, the column labels in row 1 are called what?

	A	B	C	D
1	Rank	Name	Population	County
2	1	Charlotte	885,708	Mecklenburg
3	2	Raleigh	474,069	Wake (seat), Durham
4	3	Greensboro	296,710	Guilford
5	4	Durham	278,993	Durham (seat), Wake, Orange
6	5	Winston-Salem	247,945	Forsyth
7	6	Fayetteville	211,657	Cumberland
8	7	Cary	170,282	Wake, Chatham
9	8	Wilmington	123,784	New Hanover
10	9	High Point	112,791	Guilford, Randolph, Davidson, Forsyth
11	10	Concord	96,341	Cabarrus

• Attributes
• Characteristics
• Descriptors
• Criteria

Q2. In the following spreadsheet, the observation of Greensboro describes all of the data in row 4.

	A	B	C	D
1	Rank	Name	Population	County
2	1	Charlotte	885,708	Mecklenburg
3	2	Raleigh	474,069	Wake (seat), Durham
4	3	Greensboro	296,710	Guilford
5	4	Durham	278,993	Durham (seat), Wake, Orange
6	5	Winston-Salem	247,945	Forsyth
7	6	Fayetteville	211,657	Cumberland
8	7	Cary	170,282	Wake, Chatham
9	8	Wilmington	123,784	New Hanover
10	9	High Point	112,791	Guilford, Randolph, Davidson, Forsyth
11	10	Concord	96,341	Cabarrus

• True
• False

Q3. If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B?

	A	B	C	D
1	Rank	Name	Population	County
2	1	Charlotte	885,708	Mecklenburg
3	2	Raleigh	474,069	Wake (seat), Durham
4	3	Greensboro	296,710	Guilford
5	4	Durham	278,993	Durham (seat), Wake, Orange
6	5	Winston-Salem	247,945	Forsyth
7	6	Fayetteville	211,657	Cumberland
8	7	Cary	170,282	Wake, Chatham
9	8	Wilmington	123,784	New Hanover
10	9	High Point	112,791	Guilford, Randolph, Davidson, Forsyth
11	10	Concord	96,341	Cabarrus

• Organize range
• Sort range
• Name range
• Randomize range

Q4. A data analyst types =POPULATION(C2:C11) to find the average population of the cities in this spreadsheet. However, they realize that have used the wrong formula. What syntax will correct this function? Type your answer below.

	A	B	C	D
1	Rank	Name	Population	County
2	1	Charlotte	885,708	Mecklenburg
3	2	Raleigh	474,069	Wake (seat), Durham
4	3	Greensboro	296,710	Guilford
5	4	Durham	278,993	Durham (seat), Wake, Orange
6	5	Winston-Salem	247,945	Forsyth
7	6	Fayetteville	211,657	Cumberland
8	7	Cary	170,282	Wake, Chatham
9	8	Wilmington	123,784	New Hanover
10	9	High Point	112,791	Guilford, Randolph, Davidson, Forsyth
11	10	Concord	96,341	Cabarrus

=AVERAGE(C2:C11)

Q5. In the following query, what is the asterisk (*) telling the database to do?

SELECT *

• Return one specific field.
• Select all of the data from the table.
• Filter certain information.
• Use proper syntax.

Q6. In the following query, what is FROM telling the database to do?

SELECT * FROM Orders

• From which field data should be stored
• From which table to select the data
• From which filter data should be selected
• From which field data should be updated

Q7. You are writing a query that asks a database to retrieve data about the customer with identification number 5656. The column name for customer identification numbers is customer_id. What is the correct WHERE clause syntax? Type your answer below.

WHERE customer_id = 5656

Q8. Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decided to use the _____ feature to change it to a column chart.

• image
• rename
• chart editor
• filter view

Q10. A data analyst wants to demonstrate how the population in Charlotte has increased over time. They created the chart below. What is this type of chart called?

• Column chart
• Area chart
• Line chart
• Bar chart

Foundations: Data, Data, Everywhere Week 5 Quiz Answers

Practice Quiz-1 Answers

L2 Roles of a data analyst:

Industry data example	Industry
Use geographic data to power GPS technology in cars	Technology
Use demographic data to target advertisements for a new consumer product for youths	Marketing
Use stock market data to determine which portfolios to invest in	Finance
Use bed occupancy data to determine the number of nurses and orderlies to schedule on a given shift	Healthcare
Use past booking data to accurately anticipate levels of demand for hotel rooms	Hospitality
Use population data to determine which communities need federal funding	Government

Practice Quiz-2 Answers

L3 Making decisions with data:

Q1. Data-driven decision-making and the application of data strategy are examples of what?

• Business metric
• Business platform
• Business mission
• Business task

Q2. Fill in the blank: Data-driven decision-making involves using _____ to guide business strategy.

• facts
• processes
• intuition
• tools

Practice Quiz-3 Answers

L4 Defining fairness in data:

Q1. What steps do data analysts take to ensure fairness when collecting data? Select all that apply.

Include data self-reported by individuals Clean the data provided Understand the social context Use an inclusive sample population

Q2. Avens Engineering needs more engineers, so they purchase ads on a job search website. The website’s data reveals that 86% of engineers are men. Based on that number, an analyst decides that men are more likely to be successful applicants, so they target the ads to male job seekers. What should the analyst have done instead?

• Make sure their recommendation doesn’t create or reinforce bias
• Decline to accept ads from Avens Engineering because of fairness concerns.
• Let Avens Engineering decide which type of applicants to target ads to.
• Only show ads for engineering jobs to women.

Q3. A data analyst working on a project related to truck-driver safety discovers that all reported accidents involve male drivers. What is their best course of action?

• Disregard accidents that weren’t caused by driver error.
• Take a closer look at the social context of their conclusion.
• Analyze the safety data for other types of drivers.
• Create a report to share the results with project stakeholders.

Q4. On a railway line, peak ridership occurs between 7:00 AM and 5:00 PM. The fairness of a passenger survey could be improved by over-sampling data from which group?

• Nighttime riders
• Daytime riders
• Male passengers
• Female passengers

Q5. A real estate company needs to hire a human resources assistant. The owner asks a data analyst to help them decide where to advertise the job opening. The analyst learns that the majority of human resources professionals are women, validates this finding with research, and targets ads to a women’s community college. This is fair because the analyst conducted research to make sure the information about the gender breakdown of human resources professionals was accurate.

• True
• False

Foundations: Data, Data, Everywhere Weekly Challenge 5 Answers

Q1. An online gardening magazine wants to understand why its subscriber numbers have been increasing. What kind of reports can a data analyst provide to help answer that question? Select all that apply.

• Reports that predict the success of sales leads to secure future subscribers
• Reports that compare past weather patterns to the number of people taking up gardening recently
• Reports that show how many customers shared positive comments about the gardening magazine on social media in the past year
• Reports that examine how a recent 50%-off sale affected the number of subscription purchases

Q2. A doctor’s office has discovered that patients are waiting 20 minutes longer for their appointments than in past years. A data analyst could help solve this problem by analyzing how many doctors and nurses are on staff at a given time compared to the number of patients with appointments.

• True
• False

Q3. What is the process of using facts to guide business strategy?

• Data Programming
• Data visualization
• Data ethics
• Data-driven decision-making

Q4. Fill in the blank: A business task is described as a problem or _____ a data analyst answers for a business.

• solution
• comment
• question
• complaint

Q5. Data-driven decision-making is using facts to guide business strategy. The benefits include which of the following? Select all that apply.

• Getting a complete picture of a problem and its causes
• Using data analytics to find the best possible solution to a problem
• Making the most of intuition and gut instinct
• Combining observation with objective data

Q6. It’s possible for conclusions drawn from data analysis to be both true and unfair.

• True
• False

Q7. Fill in the blank: Fairness is achieved when data analysis doesn’t create or _____ bias.

• resolve
• reinforce
• constrain
• highlight

Q8. A gym wants to start offering exercise classes. A data analyst plans to survey 10 people to determine which classes would be most popular. To ensure the data collected is fair, what steps should they take? Select all that apply.

• Collect data anonymously.
• Survey only people who don’t currently go to the gym.
• Increase the number of participants.
• Ensure participants represent a variety of profiles and backgrounds.

Next Course Quiz Answers >>

Ask Questions to Make Data-Driven Decisions

All Course Quiz Answers of Google Data Analytics Professional Certificate

Course 01: Foundations: Data, Data, Everywhere

Course 02: Ask Questions to Make Data-Driven Decisions

Course 03: Prepare Data for Exploration

Course 04: Process Data from Dirty to Clean

Course 05: Analyze Data to Answer Questions

Course 06: Share Data Through the Art of Visualization

Course 07: Data Analysis with R Programming

Course 08: Google Data Analytics Capstone: Complete a Case Study