Google Data Analytics: Course 1 –
Foundations Exam Questions with
Complete Solutions
01-018 - What is the excellence of an analyst? - Answer-speed in discovering gems
of insight
01-019 - Analysts thrive on creative and ___-____ projects. - Answer-open-ended
01-020 - Analysts enjoy the fun and thrill of ____. - Answer-exploration
01-021 - What does a Data Scientist do? (NWMUURD) - Answer-create new ways of
modeling and understanding the unknown by using raw data
01-022 - What are 3 reasons you analyze data? (PRT) - Answer-find patterns,
relationships, trends
01-023 - A critical question to ask up-front is, "How do I define ____ for this project? -
Answer-success
01-024 - Definition of a Data Set - Answer-a collection of data that can be
manipulated or analyzed as one unit
01-025 - Definition of a Data Ecosystem - Answer-a group of elements that interact
to create an environment in which to produce, store, manage, organize, analyze, and
share information
01-026 - Definition Data-Driven Decision-Making - Answer-using facts to guide
business strategy
01-027 - What are the 2 steps in Data-Driven Decision-Making? - Answer-define a
problem and analyze it
01-028 - What does the phrase, Data Analysis Life Cycle describe? - Answer-the
process of going from data to decision
01-029 - A clothing retailer collects and stores data about its sales revenue. Which of
the following would be part of its data ecosystem? Select all that apply.
a. Inventory records
b. Sales database
c. Database of competing retailers
d. The cloud that stores its database - Answer-Inventory records, Sales database,
the cloud that stores its database
01-030 - In data analytics, how is data described?
, a. An aggregate of intelligence
b. A series of calculations and statistics
c. A technical business process
d. A collection of facts - Answer-a collection of facts
01-031 - What is the process of guiding business strategy using facts?
a. Strategic improvement
b. Identification of data and decisions
c. Analytical strategy
d. Data-driven decision-making - Answer-Data-driven decision-making
01-032 - Gap analysis is a process that could help accomplish which of the following
tasks? Select all that apply.
a. Increase the efficiency of a mfg based on current assembly process
b. Improve accessibility for an education app based on its current functionality
c. Reduce a company's carbon footprint based on its current emissions
d. Spread awareness about income inequality based on local salaries - Answer-
Increase the efficiency of a mfg based on current assembly process, and Improve
accessibility for an education app based on its current functionality
01-033 - An analysis firm is conducting a data analysis of rainwater trends to give
recommendations to agricultural companies. When they reach the manage stage of
the data life cycle, which of the following might they do? Select all that apply.
a. Place their data in a location it can be accessed, even if it may not be used
b. Store and clean the data they have collected
c. Decide which security tools they will use to protect it
d. Collect and organize data relevant to rainwater - Answer-store and clean, security
tools
01-034 - The analyze phase of the data life cycle includes which of the following
steps? Select all that apply.
a. Creating a report from data
b. Choosing the format of spreadsheet headings
c. Using a formula to perform calcs
d. Using a spreadsheet to aggregate data - Answer-report, formula, spreadsheet
01-035 - A data analyst adds descriptive headers to columns of data in a
spreadsheet. How does this improve the spreadsheet?
a. Adds context
b. Improves the aesthetic appeal
c. Clarifies the business strategy
d. Eliminates unnecessary details - Answer-add context
01-036 - You are querying a database of manufacturing company suppliers. The
column name for supplier identification numbers is supplier_id. What is the correct
clause to retrieve only data about the supplier with identification number 85317?
Foundations Exam Questions with
Complete Solutions
01-018 - What is the excellence of an analyst? - Answer-speed in discovering gems
of insight
01-019 - Analysts thrive on creative and ___-____ projects. - Answer-open-ended
01-020 - Analysts enjoy the fun and thrill of ____. - Answer-exploration
01-021 - What does a Data Scientist do? (NWMUURD) - Answer-create new ways of
modeling and understanding the unknown by using raw data
01-022 - What are 3 reasons you analyze data? (PRT) - Answer-find patterns,
relationships, trends
01-023 - A critical question to ask up-front is, "How do I define ____ for this project? -
Answer-success
01-024 - Definition of a Data Set - Answer-a collection of data that can be
manipulated or analyzed as one unit
01-025 - Definition of a Data Ecosystem - Answer-a group of elements that interact
to create an environment in which to produce, store, manage, organize, analyze, and
share information
01-026 - Definition Data-Driven Decision-Making - Answer-using facts to guide
business strategy
01-027 - What are the 2 steps in Data-Driven Decision-Making? - Answer-define a
problem and analyze it
01-028 - What does the phrase, Data Analysis Life Cycle describe? - Answer-the
process of going from data to decision
01-029 - A clothing retailer collects and stores data about its sales revenue. Which of
the following would be part of its data ecosystem? Select all that apply.
a. Inventory records
b. Sales database
c. Database of competing retailers
d. The cloud that stores its database - Answer-Inventory records, Sales database,
the cloud that stores its database
01-030 - In data analytics, how is data described?
, a. An aggregate of intelligence
b. A series of calculations and statistics
c. A technical business process
d. A collection of facts - Answer-a collection of facts
01-031 - What is the process of guiding business strategy using facts?
a. Strategic improvement
b. Identification of data and decisions
c. Analytical strategy
d. Data-driven decision-making - Answer-Data-driven decision-making
01-032 - Gap analysis is a process that could help accomplish which of the following
tasks? Select all that apply.
a. Increase the efficiency of a mfg based on current assembly process
b. Improve accessibility for an education app based on its current functionality
c. Reduce a company's carbon footprint based on its current emissions
d. Spread awareness about income inequality based on local salaries - Answer-
Increase the efficiency of a mfg based on current assembly process, and Improve
accessibility for an education app based on its current functionality
01-033 - An analysis firm is conducting a data analysis of rainwater trends to give
recommendations to agricultural companies. When they reach the manage stage of
the data life cycle, which of the following might they do? Select all that apply.
a. Place their data in a location it can be accessed, even if it may not be used
b. Store and clean the data they have collected
c. Decide which security tools they will use to protect it
d. Collect and organize data relevant to rainwater - Answer-store and clean, security
tools
01-034 - The analyze phase of the data life cycle includes which of the following
steps? Select all that apply.
a. Creating a report from data
b. Choosing the format of spreadsheet headings
c. Using a formula to perform calcs
d. Using a spreadsheet to aggregate data - Answer-report, formula, spreadsheet
01-035 - A data analyst adds descriptive headers to columns of data in a
spreadsheet. How does this improve the spreadsheet?
a. Adds context
b. Improves the aesthetic appeal
c. Clarifies the business strategy
d. Eliminates unnecessary details - Answer-add context
01-036 - You are querying a database of manufacturing company suppliers. The
column name for supplier identification numbers is supplier_id. What is the correct
clause to retrieve only data about the supplier with identification number 85317?
