🌍 All Study Guides📊 Dashboard📰 Blog💡 About
Google Data Analytics Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 79

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.

A
Reports that predict the success of sales leads to secure future subscribers
B
Reports that describe how many customers shared positive comments about the gardening magazine on social media in the past yearCorrect Answer
C
Reports that examine how a recent 50%-off sale affected the number of subscription purchasesCorrect Answer
D
Reports that compare past weather patterns to the number of people asking gardening questions to their social mediaCorrect Answer
Explanation:

Analyzing historical data such as weather patterns, social media comments, and past sales would provide useful insights into the increase in subscription numbers.

QUESTION 2 OF 79

A doctor’s office discovers that patients are waiting 20 minutes longer for their appointments than in past years. In what ways could a data analyst help solve this problem? Select all that apply.

A
Analyze a recent change in the average rating for the doctor’s office on social media.
B
Analyze the number of patients seen per day compared to past years.Correct Answer
C
Analyze the average length of an appointment this year compared to past years.Correct Answer
D
Analyze how many doctors and nurses are on staff at a given time compared to the number of patients with appointments.Correct Answer
Explanation:

Analyzing appointment length, staffing numbers, and patient numbers are likely to provide useful insights to illustrate why this is happening and help solve this problem.

QUESTION 3 OF 79

A problem is an obstacle to be solved, an issue is a topic to investigate, and a question is designed to discover information.

A
TrueCorrect Answer
B
False
Explanation:

A problem is an obstacle or complication to be solved, whereas a question is designed to discover information. These two things are the foundation of business tasks.

QUESTION 4 OF 79

Data analysts answer questions and solve problems. These are called business tasks.

A
TrueCorrect Answer
B
False
Explanation:

Data analysts answer questions and solve problems, which are called business tasks.

QUESTION 5 OF 79

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

A
Making the most of intuition and gut instinct
B
Using data analytics to find the best possible solution to a problemCorrect Answer
C
Combining observation with objective dataCorrect Answer
D
Getting a complete picture of a problem and its causesCorrect Answer
Explanation:

Data-driven decision-making enables companies to use data analytics to find the best possible solution to a problem, complement observation with objective data, and get a complete picture of a problem and its causes.

QUESTION 6 OF 79

Data analysts ensure their analysis is fair for what reason?

A
Fairness helps them stay organized.
B
Fairness helps them pick and choose which data to include from a dataset.
C
Fairness helps them avoid biased conclusions.Correct Answer
D
Fairness helps them communicate with stakeholders.
Explanation:

Data analysts ensure their analysis is fair in order to ensure their analysis doesn't create or reinforce bias.

QUESTION 7 OF 79

A data analyst is analyzing fruit and vegetable sales at a grocery store. They’re able to find data on everything except red onions. If they exclude red onions from the analysis, this would be an example of creating or reinforcing bias.

A
TrueCorrect Answer
B
False
Explanation:

Fairness means ensuring that your analysis doesn't create or reinforce bias. Being inclusive, not exclusive, is an important part of fairness.

QUESTION 8 OF 79

Collaborating with a social scientist to provide insights into human bias and social contexts is an effective way to avoid bias in your data.

A
TrueCorrect Answer
B
False
Explanation:

Collaborating with a social scientist to provide insights into human bias and social contexts is an effective way to avoid bias in your data. Social scientists can help data analysts better understand human bias and social contexts.

QUESTION 9 OF 79

Fill in the blank: A doctor’s office has discovered that patients are waiting 20 minutes longer for their appointments than in past years. To help solve this problem, a data analyst could investigate how many nurses are on staff at a given time compared to the number of _____.

A
patients with appointmentsCorrect Answer
B
negative comments about the wait times on social media
C
doctors seeing new patients
D
doctors on staff at the same time
Explanation:

Analyzing staffing and patient numbers would likely provide useful insights about why patients are waiting longer for their appointment times and to help solve this problem.

QUESTION 10 OF 79

Fill in the blank: A problem is an obstacle to be solved, an issue is a topic to investigate, and a _____ is designed to discover information.

A
business task
B
theme
C
breakthrough
D
questionCorrect Answer
Explanation:

A problem is an obstacle or complication to be solved, whereas a question is designed to discover information. These two things are the foundation of business tasks.

QUESTION 11 OF 79

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

A
complaint
B
comment
C
questionCorrect Answer
D
solution
Explanation:

A business task is described as the problem or question a data analyst answers for a business.

QUESTION 12 OF 79

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

A
Data visualization
B
Data-driven decision-makingCorrect Answer
C
Data programming
D
Data ethics
Explanation:

Data-driven decision-making is using facts to guide business strategy.

QUESTION 13 OF 79

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

A
ReinforceCorrect Answer
B
resolve
C
constrain
D
highlight
Explanation:

Fairness is achieved when data analysis doesn’t create or reinforce bias.

QUESTION 14 OF 79

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.

A
Survey only people who don’t currently go to the gym.
B
Increase the number of participants.Correct Answer
C
Collect data anonymously.Correct Answer
D
Ensure participants represent a variety of profiles and backgrounds.Correct Answer
Explanation:

Ensuring participants represent a variety of profiles and backgrounds, collecting data anonymously, and surveying more than just 10 people would all help ensure the data analysis is fair.

QUESTION 15 OF 79

A magazine wants to understand why its subscribers have been increasing. A data analyst could help answer that question with a report that predicts the result of a half-price sale on future subscription rates.

A
True
B
FalseCorrect Answer
Explanation:

Predicting the effect of future sales will not answer the question of why there’s been an increase in subscribers. This type of question requires historical data to provide useful insights.

QUESTION 16 OF 79

Describe the difference between a question and a problem in data analytics.

A
A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved.Correct Answer
B
A question is a topic to investigate, whereas a problem is a subject to investigate.
C
A question can have many answers, whereas a problem only has one solution.
D
A question is uncertain, whereas a problem is clearly specified.
Explanation:

A question is designed to discover information, whereas a problem is an obstacle or complication to be solved. These two things are the foundation of business tasks.

QUESTION 17 OF 79

Which of the following examples describe fairness in data analysis? Select all that apply.

A
Picking and choosing which data to include from a dataset
B
Factoring in social contexts that could create bias in conclusionsCorrect Answer
C
Considering systematic factors that may influence dataCorrect Answer
D
Making sure a sample population represents all groupsCorrect Answer
Explanation:

Considering systematic factors that may influence your data, factoring in social contexts that could create bias in your conclusions, and making sure your sample population represents all groups are effective ways to ensure that your analysis is fair and doesn't create or reinforce bias.

QUESTION 18 OF 79

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.

A
TrueCorrect Answer
B
False
Explanation:

Analyzing staffing and patient numbers would likely provide useful insights about why patients are waiting longer for their appointment times and to help solve this problem.

QUESTION 19 OF 79

What is a question or problem that a data analyst answers for a business?

A
Complaint
B
Hypothesis
C
Mission statement
D
Business taskCorrect Answer
Explanation:

A business task is a question or problem that a data analyst answers for a business.

QUESTION 20 OF 79

Fill in the blank: Data-driven decision-making is described as using _____ to guide business strategy.

A
gut instinct
B
visualizations
C
factsCorrect Answer
D
intuition
Explanation:

Data-driven decision-making is using facts to guide business strategy.

QUESTION 21 OF 79

An online gardening magazine wants to understand why its subscriber numbers have been increasing. A data analyst discovers that significantly more people subscribe when the magazine has its annual 50%-off sale. This is an example of what?

A
Analyzing customer buying behaviorsCorrect Answer
B
Analyzing the number of customers by calculating daily foot traffic
C
Analyzing consumer preferences using artificial intelligence
D
Analyzing social media engagement
Explanation:

Data analysts help companies learn from historical data in order to make predictions. A sale’s affect on subscription purchases is an example of customer buying behavior analysis.

QUESTION 22 OF 79

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

A
TrueCorrect Answer
B
False
Explanation:

Sometimes, a conclusion may be true, but it’s unfair because it doesn’t represent all groups or it ignores social context and other systemic factors.

QUESTION 23 OF 79

A large hotel chain sees about 500 customers per week. A data analyst working there is gathering data through customer satisfaction surveys. They are anxious to begin analysis, so they start analyzing the data as soon as they receive 50 survey responses. This is an example of what? Select all that apply.

A
Failing to reward customers for participating in the survey
B
Failing to collect data anonymously
C
Failing to have a large enough sample sizeCorrect Answer
D
Failing to include diverse perspectives in data collectionCorrect Answer
Explanation:

This is an example of failing to include diverse perspectives and failing to have a large enough sample size. The first 50 survey responses are unlikely to represent the general population and may produce biased results. *COURSE CHALLENGE*

QUESTION 24 OF 79

Scenario 1, question 1-11 You’ve just started a new job as a data analyst. You’re working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you. She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership. You know that it's important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations. One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need. Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). Considering the size of your dataset, you decide a spreadsheet will be the best tool for your project. You proceed by downloading the data from the database. Describe why this is the best choice.

A
Spreadsheets work well for processing and analyzing a small dataset, like the one you’re using.Correct Answer
B
Spreadsheets are most effective when working with queries.
C
Only spreadsheets let you download and upload data.
D
Databases can’t be used for analysis.
Explanation:

A spreadsheet is a smart choice when working with a dataset of 38 rows and five columns.

QUESTION 25 OF 79

Scenario 1 continued You’ve downloaded the data from your company database and imported it into a spreadsheet. To use the dataset for this scenario, click the link below and select “Use Template.” Link to template: Course Challenge - Scenario 1 OR If you don’t have a Google account, you can download the template directly from the attachment below. Now, it’s time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice there’s missing data in one of the rows. What might you do to fix this problem? Select all that apply.

A
Delete the row with the missing data point
B
Sort the spreadsheet so the row with missing data is at the bottom
C
Ask you supervisor for guidanceCorrect Answer
D
Ask a colleague on your team how they've handled similar issues in the pastCorrect Answer
Explanation:

You could ask your supervisor or a colleague for guidance. Asking questions helps you learn and avoid mistakes.

QUESTION 26 OF 79

Scenario 1 continued Once you’ve found the missing information, you analyze your dataset. During analysis, you create a new column F. At the top of the column, you add: Average Percentage of Total Sales - Splashtastic. What is this column label called?

A
An attributeCorrect Answer
B
A headline
C
A reference
D
A title
Explanation:

An attribute is a characteristic or quality of data used to label a column.

QUESTION 27 OF 79

Scenario 1 continued Next, you determine the average total daily sales over the past 12 months at all stores. The range that contains these sales is E2:E39. The correct syntax is =AVERAGE(E2:E39).

A
TrueCorrect Answer
B
False
Explanation:

The correct syntax is =AVERAGE(E2:E39). The function begins with an equal sign (=), then the word AVERAGE. The range is E2 through E39.

QUESTION 28 OF 79

Scenario 1 continued You’ve reached the share phase of the data analysis process. It involves which of the following? Select all that apply.

A
Stop selling Splashtastic because it doesn't represent a large percentage of total sales.
B
Prepare a slideshow about Splashtastic’s sales and practice your presentation.Correct Answer
C
Present your findings about Splashtastic to stakeholders.Correct Answer
D
Create a data visualization to highlight the Splashtastic sales insights you've discovered.Correct Answer
Explanation:

The share phase involves creating data visualizations, preparing your presentation, and communicating your findings to stakeholders.

QUESTION 29 OF 79

Scenario 1 continued You’ve downloaded the data from your company database and imported it into a spreadsheet. To use the dataset for this scenario, click the link below and select “Use Template.” Course Challenge - Scenario 1 OR If you don’t have a Google account, you can download the template directly from the attachment below. Now, it’s time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice that information about Splashtastic is missing in one of the rows. You are unsure of how to proceed, so the best course of action is to ask your supervisor for guidance.

A
TrueCorrect Answer
B
False
Explanation:

The best course of action is to ask your supervisor for guidance. Asking questions helps you learn and avoid mistakes.

QUESTION 30 OF 79

Scenario 1 continued Next, you determine the average total daily sales over the past 12 months at all stores. The range that contains these sales is E2:E39. Identify the correct way to write your function.

A
=AVERAGE(E2,E39)
B
=AVERAGE(E2:E39)Correct Answer
C
=AVERAGE(E2-E39)
D
=AVERAGE(E2+E39)
Explanation:

The function begins with an equal sign (=), and the range is E2 through E39.

QUESTION 31 OF 79

Scenario 1 continued Once you’ve found the missing information, you analyze your dataset. During analysis, you create a new column F. At the top of the column, you add: Average Percentage of Total Sales - Splashtastic. In data analytics, this column label is called an attribute.

A
TrueCorrect Answer
B
False
Explanation:

This column label is an attribute, which is a characteristic or quality of data used to label a column.

QUESTION 32 OF 79

Scenario 1 continued You’ve reached the share phase of the data analysis process. It involves creating a data visualization to highlight the Splashtastic sales insights you've discovered.

A
TrueCorrect Answer
B
False
Explanation:

The share phase involves creating data visualizations, preparing your presentation, and communicating your findings to stakeholders.

QUESTION 33 OF 79

You know that spreadsheets work well for processing and analyzing a small dataset, like the one you’re using. To get the data from the database into a spreadsheet, what should you do?

A
Email a copy of the dataset to your company email address.
B
Copy and paste the data into a spreadsheet.
C
Download the data as a .CSV file, then import it into a spreadsheet.Correct Answer
D
Use Tableau to convert the data into a spreadsheet.
Explanation:

Downloading data from a database into a .CSV file, then importing it into a spreadsheet, will enable you to process and analyze the small dataset effectively.

QUESTION 34 OF 79

Scenario 1 continued You’ve downloaded the data from your company database and imported it into a spreadsheet. To use the dataset for this scenario, click the link below and select “Use Template.” Now, it’s time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice that information about Splashtastic is missing in row 16. The best course of action is to delete the row with missing data from your dataset so it doesn’t get in the way of your results.

A
True
B
FalseCorrect Answer
QUESTION 35 OF 79

Scenario 2, questions 12-21 You’ve been working for the nonprofit National Dental Society (NDS) as a junior data analyst for about two months. The mission of the NDS is to help its members advance the oral health of their patients. NDS members include dentists, hygienists, and dental office support staff. The NDS is passionate about patient health. Part of this involves automatically scheduling follow-up appointments after crown replacement, emergency dental surgery, and extraction procedures. NDS believes the follow-up is an important step to ensure patient recovery and minimize infection. Unfortunately, many patients don’t show up for these appointments, so the NDS wants to create a campaign to help its members learn how to encourage their patients to take follow-up appointments seriously. If successful, this will help the NDS achieve its mission of advancing the oral health of all patients. Your supervisor has just sent you an email saying that you’re doing very well on the team, and he wants to give you some additional responsibility. He describes the issue of many missed follow-up appointments. You are tasked with analyzing data about this problem and presenting your findings using data visualizations. An NDS member with three dental offices in Colorado offers to share its data on missed appointments. So, your supervisor uses a database query to access the dataset from the dental group. The query instructs the database to retrieve all patient information from the member’s three dental offices, located in zip code 81137. The table is dental_data_table, and the column name is zip_code. You have written the following query, but received an error when it ran. What is the clause that will correct this query? (Image S2Q12)

A
WHERE zip_code = 81137
B
WHERE_zip_code = 81137
C
WHERE zip_code 81137Correct Answer
D
WHERE = 81137
QUESTION 36 OF 79

Scenario 2 continued As you’re reviewing the dataset, you notice that there are a disproportionate number of senior citizens. So, you investigate further and find out that this zip code represents a rural community in Colorado with about 800 residents. In addition, there’s a large assisted-living facility in the area. Nearly 300 of the residents in the 81137 zip code live in the facility. You recognize that’s a sizable number, so you want to find out if age has an effect on a patient’s likelihood to attend a follow-up dental appointment. You analyze the data, and your analysis reveals that older people tend to miss follow-ups more than younger people. So, you do some research online and discover that people over the age 60 are 50% more likely to miss dentist appointments. Sometimes this is because they’re on a fixed income. Also, many senior citizens lack transportation to get to and from appointments. With this new knowledge, you write an email to your supervisor expressing your concerns about the dataset. He agrees with your concerns, but he’s also impressed with what you’ve learned and thinks your findings could be very important to the project. He asks you to change the business task. Now, the NDS campaign will be about educating dental offices on the challenges faced by senior citizens and finding ways to help them access quality dental care. Fill in the blank: Changing the business task involves defining a new _____.

A
gap analysis plan
B
question or problem to be solvedCorrect Answer
C
graphical representation of the data
D
data-cleaning strategy
Explanation:

A business task is the question or problem data analysis answers for a business.

QUESTION 37 OF 79

Scenario 2 continued You continue with your analysis. In the end, your findings support what you discovered during your online research: As people get older, they’re less likely to attend follow-up dental visits. But you’re not done yet. You know that data should be combined with human insights in order to lead to true data-driven decision-making. So, your next step is to share this information with people who are familiar with the problem. They’ll help verify the results of your data analysis. The people who are familiar with a problem and help verify the results of data analysis include customers and competitors.

A
True
B
FalseCorrect Answer
Explanation:

Subject-matter experts look at the results of data analysis to identify any inconsistencies, make sense of the gray areas, and eventually validate the choices being made.

QUESTION 38 OF 79

Scenario 2 continued The subject-matter experts are impressed by your analysis. The team agrees to move to the next step: data visualization. You know it’s important that stakeholders at NDS can quickly and easily understand that older people are less likely to attend important follow-up dental appointments. This will help them create an effective campaign for members. It’s time to create your presentation to stakeholders. It will include a data visualization that demonstrates the trend of people being less likely to attend follow-up appointments as they get older. Which type of chart will be most effective?

A
A doughnut chart
B
A line chartCorrect Answer
C
A pie chart
D
A table
Explanation:

A line chart is effective for tracking trends over time, such as people attending fewer follow-up appointments as they get older.

QUESTION 39 OF 79

The table is dental_data_table, and the column name is zip_code. How do you complete the following query? (Image S2Q16)

A
WHERE = 81137
B
zip_code = 81137
C
WHERE_zip_code = 81137
D
WHERE zip_code = 81137Correct Answer
Explanation:

The correct syntax is WHERE zip_code = 81137. WHERE indicates where to look for information. The column name is zip_code. And the database is being asked to return only records matching zip code 81137.

QUESTION 40 OF 79

Scenario 2 continued The dataset your supervisor retrieved and imported into a spreadsheet includes a list of patients, their demographic information, dental procedure types, and whether they attended their follow-up appointment. To use the dataset for this scenario, click the link below and select “Use Template.” Link to template: Course Challenge - Scenario 2 OR If you don’t have a Google account, you can download the template directly from the attachment below. The patient demographic information includes data such as age and gender. As you’re learning, it’s your responsibility as a data analyst to make sure your analysis is fair. The fact that the dataset includes people who all live in the same zip code might get in the way of fairness.

A
TrueCorrect Answer
B
False
Explanation:

It’s your responsibility as a data analyst to make sure your analysis is fair. Although many zip codes do reflect diverse populations, a better choice would be to include data about people who live in multiple zip codes.

QUESTION 41 OF 79

Scenario 2 continued As you’re reviewing the dataset, you notice that there are a disproportionate number of senior citizens. So, you investigate further and find out that this zip code represents a rural community in Colorado with about 800 residents. In addition, there’s a large assisted-living facility in the area. Nearly 300 of the residents in the 81137 zip code live in the facility. You recognize that’s a sizable number, so you want to find out if age has an effect on a patient’s likelihood to attend a follow-up dental appointment. You analyze the data, and your analysis reveals that older people tend to miss follow-ups more than younger people. So, you do some research online and discover that people over the age 60 are 50% more likely to miss dentist appointments. Sometimes this is because they’re on a fixed income. Also, many senior citizens lack transportation to get to and from appointments. With this new knowledge, you write an email to your supervisor expressing your concerns about the dataset. He agrees with your concerns, but he’s also impressed with what you’ve learned and thinks your findings could be very important to the project. He asks you to change the business task. Now, the NDS campaign will be about educating dental offices on the challenges faced by senior citizens and finding ways to help them access quality dental care. Changing the business task involves which of the following?

A
Conducting a gap analysis
B
Creating a graphical representation of the data
C
Defining the new question or problem to be solvedCorrect Answer
D
Using a database instead of a spreadsheet
Explanation:

A business task is the question or problem data analysis answers for a business.

QUESTION 42 OF 79

Scenario 2 continued The subject-matter experts are impressed by your analysis. The team agrees to move to the next step: data visualization. You know it’s important that stakeholders at NDS can quickly and easily understand that older people are less likely to attend important follow-up dental appointments. This will help them create an effective campaign for members. It’s time to create your presentation to stakeholders. It will include a data visualization that demonstrates the trend of people being less likely to attend follow-up appointments as they get older. For this, a pie chart will be most effective.

A
True
B
FalseCorrect Answer
Explanation:

A pie chart is used to represent the proportions of certain data categories compared to the whole. A line chart would be effective for tracking trends over time, such as people attending fewer appointments as they get older.

QUESTION 43 OF 79

Scenario 2 continued The dataset your supervisor retrieved and imported into a spreadsheet includes a list of patients, their demographic information, dental procedure types, and whether they attended their follow-up appointment. To use the dataset for this scenario, click the link below and select “Use Template.” Link to template: Course Challenge - Scenario 2 OR If you don’t have a Google account, you can download the template directly from the attachment below. The patient demographic information includes data such as age and gender. As you’re learning, it’s your responsibility as a data analyst to make sure your analysis is fair. Which aspect of patient demographics might get in the way of fairness?

A
The dataset contains patient identification numbers.
B
The dataset represents people who are single.
C
The dataset includes people who all live in the same zip code.Correct Answer
D
The dataset indicates which dental procedure the patients had performed
Explanation:

It’s your responsibility as a data analyst to make sure your analysis is fair. Although many zip codes do reflect diverse populations, a better choice would be to include data about people who live in multiple zip codes.

QUESTION 44 OF 79

Scenario 2 continued You continue with your analysis. In the end, your findings support what you discovered during your online research: As people get older, they’re less likely to attend follow-up dental visits. But you’re not done yet. You know that data should be combined with human insights in order to lead to true data-driven decision-making. So, your next step is to share this information with people who are familiar with the problem. They’ll help verify the results of your data analysis. The people who are familiar with a problem and help verify the results of data analysis are called subject-matter experts. What are their roles in the process? Select all that apply.

A
Collect, transform, and organize data
B
Identify inconsistencies in the analysisCorrect Answer
C
Validate the choices being madeCorrect Answer
D
Offer insights into the business problemCorrect Answer
Explanation:

Subject-matter experts can offer insights into the business problem, identify inconsistencies in the analysis, and validate the choices being made.

QUESTION 45 OF 79

Scenario 1, question 1-5 You’ve just started a new job as a data analyst. You’re working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you. She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership. You know that it's important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations. One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need. Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). Considering the size of your dataset, what’s the best way to proceed with the process and analyze steps?

A
Download the data, then use a spreadsheet to process and analyze it.Correct Answer
B
Use SQL to process and analyze the data.
C
Continue using the company database to process and analyze the data.
D
Upload the data, then process and analyze it using Tableau.
QUESTION 46 OF 79

Scenario 1 continued Once you’ve found the missing information, you analyze your dataset. During analysis, you create a new column F. At the top of the column, you add the attribute Average Percentage of Total Sales - Splashtastic. Fill in the blank: An attribute is a _______ or quality of data used to label a column.

A
response
B
characteristicCorrect Answer
C
headline
D
number
QUESTION 47 OF 79

Scenario 1 continued Next, you determine the average total daily sales over the past 12 months at all stores. The entire range of cells that contain these sales are E2:E39. Identify the correct way to write your formula.

A
=AVERAGE(E2+E39)
B
=AVERAGE(E2-E39)
C
=AVERAGE(E2:E39)Correct Answer
D
=AVERAGE(E2,E39)
QUESTION 48 OF 79

Scenario 1 continued You’ve reached the share phase of the data analysis process. What can you do in this phase to share the Splashtastic sales insights you've discovered?

A
Present your findings to stakeholders.Correct Answer
B
Revisit the analyze phase.
C
Establish a repository for the data.
D
Present your findings to customers.
QUESTION 49 OF 79

Scenario 2 continued The dataset your supervisor retrieved and imported into a spreadsheet includes a list of patients, their demographic information, dental procedure types, and whether they attended their follow-up appointment. To use the dataset for this scenario, click the link below and select “Use Template.” If you don’t have a Google account, you can download the template directly from the attachment below. The patient demographic information includes data such as age and gender. As you’re learning, it’s your responsibility as a data analyst to make sure your analysis is fair. Looking at the geographic data, you notice that all the patients live in the same zip code. How might this negatively impact the analysis?

A
It could cause the analysis to be fair.
B
It could cause the analysis to be biased.Correct Answer
C
It could cause the analysis to be useless.
D
It could cause the analysis to be unbiased.
QUESTION 50 OF 79

Scenario 2 continued As you’re reviewing the dataset, you notice that there are a disproportionate number of senior citizens. So, you investigate further and find out that this zip code represents a rural community in Colorado with about 800 residents. In addition, there’s a large assisted-living facility in the area. Nearly 300 of the residents in the 81137 zip code live in the facility. You recognize that’s a sizable number, so you want to find out if age has an effect on a patient’s likelihood to attend a follow-up dental appointment. You analyze the data, and your analysis reveals that older people tend to miss follow-ups more than younger people. So, you do some research online and discover that people over the age 60 are 50% more likely to miss dentist appointments. Sometimes this is because they’re on a fixed income. Also, many senior citizens lack transportation to get to and from appointments. With this new knowledge, you write an email to your supervisor expressing your concerns about the dataset. He agrees with your concerns, but he’s also impressed with what you’ve learned and thinks your findings could be very important to the project. He asks you to change the business task. Now, the NDS campaign will be about educating dental offices on the challenges faced by senior citizens and finding ways to help them access quality dental care. Changing the business task involves defining the new question or problem to be solved.

A
TrueCorrect Answer
B
False
QUESTION 51 OF 79

Scenario 2 continued The subject-matter experts are impressed by your analysis. The team agrees to move to the next step: data visualization. You know it’s important that stakeholders at NDS can quickly and easily understand that older people are less likely to attend important follow-up dental appointments than younger people. This will help them create an effective campaign for members. It’s time to create your presentation to stakeholders. It will include a data visualization that demonstrates the lifetime trend of people being less likely to attend follow-up appointments as they get older. Why would a line chart be the most effective in representing this?

A
Line charts represent data values as proportionally sized wedges.
B
Line charts arrange data values into rows.
C
Line charts arrange data values into columns.
D
Line charts are effective in displaying points in series.Correct Answer
QUESTION 52 OF 79

Scenario 1 continued Next, you determine the average total daily sales over the past 12 months at all stores. The entire range of cells that contain these sales are E2:E39. To do this, you use type a formula. Fill in the blank to complete the formula correctly: =AVERAGE_____.

A
E2:E39
B
E2-E39
C
(E2:E39)Correct Answer
D
(E2-E39)
QUESTION 53 OF 79

Scenario 2, questions 6-10 You’ve been working for the nonprofit National Dental Society (NDS) as a junior data analyst for about two months. The mission of the NDS is to help its members advance the oral health of their patients. NDS members include dentists, hygienists, and dental office support staff. The NDS is passionate about patient health. Part of this involves automatically scheduling follow-up appointments after crown replacement, emergency dental surgery, and extraction procedures. NDS believes the follow-up is an important step to ensure patient recovery and minimize infection. Unfortunately, many patients don’t show up for these appointments, so the NDS wants to create a campaign to help its members learn how to encourage their patients to take follow-up appointments seriously. If successful, this will help the NDS achieve its mission of advancing the oral health of all patients. Your supervisor has just sent you an email saying that you’re doing very well on the team, and he wants to give you some additional responsibility. He describes the issue of many missed follow-up appointments. You are tasked with analyzing data about this problem and presenting your findings using data visualizations. An NDS member with three dental offices in Colorado offers to share its data on missed appointments. So, your supervisor uses a database query to access the dataset from the dental group. The query instructs the database to retrieve all patient information from the member’s three dental offices, located in zip code 81137. The table is dental_data_table, and the column name is zip_code. You write the following query, but get an error. What statement will correct the problem? SELECT * FROM dental_data_table

A
WHERE zip code = 81137
B
WHERE zip_code = 81137Correct Answer
C
WHERE 81137
D
zip_code = 81137
E
WHERE_zip code = 81137
QUESTION 54 OF 79

Scenario 2 continued The dataset your supervisor retrieved and imported into a spreadsheet includes a list of patients, their demographic information, dental procedure types, and whether they attended their follow-up appointment. To use the dataset for this scenario, click the link below and select “Use Template.” Fill in the blank: The fact that the dataset includes people who all live in the same zip code might get in the way of ______.

A
spreadsheet formulas or functions
B
data visualization
C
accuracy
D
fairnessCorrect Answer
QUESTION 55 OF 79

Scenario 2 continued You continue with your analysis. In the end, your findings support what you discovered during your online research: As people get older, they’re less likely to attend follow-up dental visits. But you’re not done yet. You know that data should be combined with human insights in order to lead to true data-driven decision-making. So, your next step is to share this information with people who are familiar with the problem professionally. They’ll help verify the results of your data analysis. Fill in the blank: Subject matter experts are people who are familiar with a problem. They can help by identifying inconsistencies in the analysis, _____, and validating the choices being made.

A
creating a presentation with the data
B
offering insights into the business problemCorrect Answer
C
redefining the business problem
D
collecting data relevant to the business problem
QUESTION 56 OF 79

Scenario 1, question 1-5 You’ve just started a new job as a data analyst for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you. She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership. You know that it's important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations. One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need. Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). You decide to use a spreadsheet to work with the data because you know that spreadsheets work well for processing and analyzing a small dataset, like the one you’re using. Fill in the blank: To get the data from the database into a spreadsheet, you would first download the data as a .CSV file, then _____ it into a spreadsheet.

A
paste
B
export
C
email
D
importCorrect Answer
QUESTION 57 OF 79

Scenario 1 continued You’ve downloaded the data from your company database and imported it into a spreadsheet. IMPORTANT: To answer questions using this dataset for the scenario, click the link below and select the “Use Template” button before answering the questions. Now, it’s time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice that information about Splashtastic is missing for Store Number 15 in Row 16. Which of the following would be an appropriate course of action?

A
Replace the row with the average values of the other data points.
B
Sort the spreadsheet so the row with missing data is at the bottom.
C
Investigate previous projects and see how this was dealt with there.Correct Answer
D
Delete the row with the missing data point.
QUESTION 58 OF 79

Scenario 1 continued Once you’ve found the missing information, you analyze your dataset. During analysis, you create a new column F. You label the top of the column Average Percentage of Total Sales - Splashtastic. Fill in the blank: The column label you add to column F is known as ______.

A
an attributeCorrect Answer
B
a title
C
a reference
D
an observation
QUESTION 59 OF 79

Scenario 1 continued Fill in the blank: You’ve reached the share phase of the data analysis process. One of the things that you can do in this phase is to prepare a _____ about Splashtastic’s sales and practice your presentation.

A
prediction
B
finding
C
record
D
slideshowCorrect Answer
QUESTION 60 OF 79

Scenario 1, question 1-5 You’ve just started a new job as a data analyst for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you.She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership. You know that it's important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations. One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need. Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). You decide to use a spreadsheet to work with the data because you know that spreadsheets work well for processing and analyzing a small dataset, like the one you’re using. Fill in the blank: To get the data from the database into a spreadsheet, you would first _____ the data as a .CSV file, then import it into a spreadsheet.

A
downloadCorrect Answer
B
print
C
email
D
copy and paste
QUESTION 61 OF 79

Scenario 2, questions 6-10 You’ve been working for the nonprofit National Dental Society (NDS) as a junior data analyst for about two months. The mission of the NDS is to help its members advance the oral health of their patients. NDS members include dentists, hygienists, and dental office support staff. The NDS is passionate about patient health. Part of this involves automatically scheduling follow-up appointments after crown replacement, emergency dental surgery, and extraction procedures. NDS believes the follow-up is an important step to ensure patient recovery and minimize infection. Unfortunately, many patients don’t show up for these appointments, so the NDS wants to create a campaign to help its members learn how to encourage their patients to take follow-up appointments seriously. If successful, this will help the NDS achieve its mission of advancing the oral health of all patients. Your supervisor has just sent you an email saying that you’re doing very well on the team, and he wants to give you some additional responsibility. He describes the issue of many missed follow-up appointments. You are tasked with analyzing data about this problem and presenting your findings using data visualizations. An NDS member with three dental offices in Colorado offers to share its data on missed appointments. So, your supervisor uses a database query to access the dataset from the dental group. The query instructs the database to retrieve all patient information from the member’s three dental offices, located in zip code 81137. The table is dental_data_table, and the column name is zip_code. The following query is incomplete. SELECT * FROM dental_data_table Which of the following is the missing third line from this query?

A
WHERE = 81137
B
zip_code = 81137
C
WHERE zip_code = 81137Correct Answer
D
WHERE_zip_code = 81137
QUESTION 62 OF 79

Scenario 2 continued The dataset your supervisor retrieved and imported into a spreadsheet includes a list of patients, their demographic information, dental procedure types, and whether they attended their follow-up appointment. The patient demographic information includes data such as age, gender, and home address. You review the demographic data, paying particular attention to geography. What geographic aspect of the data may negatively impact fairness?

A
The patients all live in the same city.
B
The patients all live in houses.
C
The patients all live in the same country.
D
The patients all live in the same zip code.Correct Answer
QUESTION 63 OF 79

Scenario 2 continued You continue with your analysis. In the end, your findings support what you discovered during your online research: As people get older, they’re less likely to attend follow-up dental visits. But you’re not done yet. You know that data should be combined with human insights in order to lead to true data-driven decision-making. So, your next step is to share this information with people who are familiar with the problem professionally. They’ll help verify the results of your data analysis. Fill in the blank: The people who are familiar with a problem and help verify the results of data analysis are _____.

A
subject-matter expertsCorrect Answer
B
customers
C
data scientists
D
stakeholders
QUESTION 64 OF 79

Scenario 2 continued The subject-matter experts are impressed by your analysis. The team agrees to move to the next step: data visualization. You know it’s important that stakeholders at NDS can quickly and easily understand that older people are less likely to attend important follow-up dental appointments. This will help them create an effective campaign for members. It’s time to create your presentation to stakeholders. It will include a data visualization that depicts the relationship between age and follow-up dental appointment attendance rates over a lifetime. A doughnut chart will be the most effective visualization of this data.

A
True
B
FalseCorrect Answer
QUESTION 65 OF 79

Scenario 1 continued Once you’ve found the missing information, you analyze your dataset. During analysis, you create a new column F. At the top of the column, you add the attribute Average Percentage of Total Sales - Splashtastic. Fill in the blank: An attribute is a characteristic or _____ of data used to label a column.

A
observation
B
number
C
qualityCorrect Answer
D
collection
QUESTION 66 OF 79

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

A
Clean the data provided
B
Understand the social contextCorrect Answer
C
Include data self-reported by individualsCorrect Answer
D
Use an inclusive sample populationCorrect Answer
QUESTION 67 OF 79

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?

A
Decline to accept ads from Avens Engineering because of fairness concerns.
B
Make sure their recommendation doesn’t create or reinforce biasCorrect Answer
C
Let Avens Engineering decide which type of applicants to target ads to.
D
Only show ads for the engineering jobs to women.
QUESTION 68 OF 79

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?

A
Female passengers
B
Male passengers
C
Nighttime ridersCorrect Answer
D
Daytime riders
QUESTION 69 OF 79

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 gender breakdown of human resources professionals was accurate.

A
True
B
FalseCorrect Answer
QUESTION 70 OF 79

A data analyst is analyzing fruit and vegetable sales at a grocery store. They’re able to find data on everything except red onions. What’s the best course of action?

A
Exclude all onion varieties from the analysis.
B
Exclude red onions from the analysis.
C
Use the data on white onions instead, as they’re both onion varieties.
D
Ask a teammate for help finding data on red onions.Correct Answer
QUESTION 71 OF 79

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

A
ReinforceCorrect Answer
B
resolve
C
constrain
D
highlight
QUESTION 72 OF 79

Scenario 1, question 1-5

A
Download the data, then use a spreadsheet to process and analyze it.Correct Answer
B
Use SQL to process and analyze the data.
C
Upload the data, then process and analyze it using Tableau.
D
Continue using the company database to process and analyze the data.
QUESTION 73 OF 79

Scenario 1 continued

A
Ask you supervisor for guidanceCorrect Answer
B
Delete the row with the missing data point
C
Ask a colleague on your team how they’ve handled similar issues in the pastCorrect Answer
D
Sort the spreadsheet so the row with missing data is at the bottom
QUESTION 74 OF 79

Scenario 2, question 6-10

A
zip_code = 81137
B
WHERE zip_code = 81137Correct Answer
C
WHERE_zip_code = 81137
D
WHERE = 81137
QUESTION 75 OF 79

Scenario 2 continued

A
TrueCorrect Answer
B
False
C
zip_code = 81137
D
WHERE zip_code = 81137Correct Answer
E
WHERE_zip_code = 81137
F
WHERE = 81137
QUESTION 76 OF 79

Scenario 1, question 1-11

A
Spreadsheets work well for processing and analyzing a small dataset, like the one you’re using.Correct Answer
B
Spreadsheets are most effective when working with queries.
C
Only spreadsheets let you download and upload data.
D
Databases can’t be used for analysis.
QUESTION 77 OF 79

 Scenario 2, questions 12-21

A
WHERE zip_code = 81137
B
WHERE_zip_code = 81137
C
WHERE zip_code 81137Correct Answer
D
WHERE = 81137
QUESTION 78 OF 79

The table is dental_data_table, and the column name is zip_code. How do you complete the following query?

A
WHERE = 81137
B
zip_code = 81137
C
WHERE_zip_code = 81137
D
WHERE zip_code = 81137Correct Answer
QUESTION 79 OF 79

Scenario 2, questions 6-10

Ready to test your recall?

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.

💡Select all 3 correct answers before submitting (0 of 3 selected).
A
Reports that predict the success of sales leads to secure future subscribers
B
Reports that describe how many customers shared positive comments about the gardening magazine on social media in the past year
C
Reports that examine how a recent 50%-off sale affected the number of subscription purchases
D
Reports that compare past weather patterns to the number of people asking gardening questions to their social media

How confident are you in this answer?