Google Data Analytics Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 65

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 describe how many customers shared positive comments about the gardening magazine on social media in the past yearCorrect Answer

Reports that examine how a recent 50%-off sale affected the number of subscription purchasesCorrect Answer

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 65

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.

Analyze a recent change in the average rating for the doctor’s office on social media.

Analyze the number of patients seen per day compared to past years.Correct Answer

Analyze the average length of an appointment this year compared to past years.Correct Answer

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 65

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

TrueCorrect Answer

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 65

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

TrueCorrect Answer

False

Explanation:

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

QUESTION 5 OF 65

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

Making the most of intuition and gut instinct

Using data analytics to find the best possible solution to a problemCorrect Answer

Combining observation with objective dataCorrect Answer

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 65

Data analysts ensure their analysis is fair for what reason?

Fairness helps them stay organized.

Fairness helps them pick and choose which data to include from a dataset.

Fairness helps them avoid biased conclusions.Correct Answer

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 65

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.

TrueCorrect Answer

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 65

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

TrueCorrect Answer

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 65

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

patients with appointmentsCorrect Answer

negative comments about the wait times on social media

doctors seeing new patients

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 65

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.

business task

theme

breakthrough

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 65

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

complaint

comment

questionCorrect Answer

solution

Explanation:

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

QUESTION 12 OF 65

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

Data visualization

Data-driven decision-makingCorrect Answer

Data programming

Data ethics

Explanation:

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

QUESTION 13 OF 65

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

ReinforceCorrect Answer

resolve

constrain

highlight

Explanation:

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

QUESTION 14 OF 65

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.

Survey only people who don’t currently go to the gym.

Increase the number of participants.Correct Answer

Collect data anonymously.Correct Answer

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 65

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.

True

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 65

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

A question is designed to discover information, whereas a problem is an obstacle or complication that needs to be solved.Correct Answer

A question is a topic to investigate, whereas a problem is a subject to investigate.

A question can have many answers, whereas a problem only has one solution.

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 65

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

Picking and choosing which data to include from a dataset

Factoring in social contexts that could create bias in conclusionsCorrect Answer

Considering systematic factors that may influence dataCorrect Answer

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 65

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.

TrueCorrect Answer

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 65

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

Complaint

Hypothesis

Mission statement

Business taskCorrect Answer

Explanation:

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

QUESTION 20 OF 65

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

gut instinct

visualizations

factsCorrect Answer

intuition

Explanation:

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

QUESTION 21 OF 65

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?

Analyzing customer buying behaviorsCorrect Answer

Analyzing the number of customers by calculating daily foot traffic

Analyzing consumer preferences using artificial intelligence

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 65

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

TrueCorrect Answer

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 65

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.

Failing to reward customers for participating in the survey

Failing to collect data anonymously

Failing to have a large enough sample sizeCorrect Answer

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 65

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.

Spreadsheets work well for processing and analyzing a small dataset, like the one you’re using.Correct Answer

Spreadsheets are most effective when working with queries.

Only spreadsheets let you download and upload data.

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 65

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.

Delete the row with the missing data point

Sort the spreadsheet so the row with missing data is at the bottom

Ask you supervisor for guidanceCorrect Answer

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 65

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?

An attributeCorrect Answer

A headline

A reference

A title

Explanation:

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

QUESTION 27 OF 65

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

TrueCorrect Answer

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 65

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

Stop selling Splashtastic because it doesn't represent a large percentage of total sales.

Prepare a slideshow about Splashtastic’s sales and practice your presentation.Correct Answer

Present your findings about Splashtastic to stakeholders.Correct Answer

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 65

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.

TrueCorrect Answer

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 65

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.

=AVERAGE(E2,E39)

=AVERAGE(E2:E39)Correct Answer

=AVERAGE(E2-E39)

=AVERAGE(E2+E39)

Explanation:

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

QUESTION 31 OF 65

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.

TrueCorrect Answer

False

Explanation:

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

QUESTION 32 OF 65

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.

TrueCorrect Answer

False

Explanation:

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

QUESTION 33 OF 65

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?

Email a copy of the dataset to your company email address.

Copy and paste the data into a spreadsheet.

Download the data as a .CSV file, then import it into a spreadsheet.Correct Answer

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 65

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.

True

FalseCorrect Answer

QUESTION 35 OF 65

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)

WHERE zip_code = 81137

WHERE_zip_code = 81137

WHERE zip_code 81137Correct Answer

WHERE = 81137

QUESTION 36 OF 65

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

gap analysis plan

question or problem to be solvedCorrect Answer

graphical representation of the data

data-cleaning strategy

Explanation:

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

QUESTION 37 OF 65

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.

True

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 65

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 doughnut chart

A line chartCorrect Answer

A pie chart

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 65

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

WHERE = 81137

zip_code = 81137

WHERE_zip_code = 81137

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 65

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.

TrueCorrect Answer

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 65

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?

Conducting a gap analysis

Creating a graphical representation of the data

Defining the new question or problem to be solvedCorrect Answer

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 65

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.

True

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 65

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?

The dataset contains patient identification numbers.

The dataset represents people who are single.

The dataset includes people who all live in the same zip code.Correct Answer

The dataset indicates which dental procedure the patients had performed

Explanation:

QUESTION 44 OF 65

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.

Collect, transform, and organize data

Identify inconsistencies in the analysisCorrect Answer

Validate the choices being madeCorrect Answer

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 65

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?

Download the data, then use a spreadsheet to process and analyze it.Correct Answer

Use SQL to process and analyze the data.

Continue using the company database to process and analyze the data.

Upload the data, then process and analyze it using Tableau.

QUESTION 46 OF 65

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.

response

characteristicCorrect Answer

headline

number

QUESTION 47 OF 65

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.

=AVERAGE(E2+E39)

=AVERAGE(E2-E39)

=AVERAGE(E2:E39)Correct Answer

=AVERAGE(E2,E39)

QUESTION 48 OF 65

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?

Present your findings to stakeholders.Correct Answer

Revisit the analyze phase.

Establish a repository for the data.

Present your findings to customers.

QUESTION 49 OF 65

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?

It could cause the analysis to be fair.

It could cause the analysis to be biased.Correct Answer

It could cause the analysis to be useless.

It could cause the analysis to be unbiased.

QUESTION 50 OF 65

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.

TrueCorrect Answer

False

QUESTION 51 OF 65

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?

Line charts represent data values as proportionally sized wedges.

Line charts arrange data values into rows.

Line charts arrange data values into columns.

Line charts are effective in displaying points in series.Correct Answer

QUESTION 52 OF 65

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

E2:E39

E2-E39

(E2:E39)Correct Answer

(E2-E39)

QUESTION 53 OF 65

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

WHERE zip code = 81137

WHERE zip_code = 81137Correct Answer

WHERE 81137

zip_code = 81137

WHERE_zip code = 81137

QUESTION 54 OF 65

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

spreadsheet formulas or functions

data visualization

accuracy

fairnessCorrect Answer

QUESTION 55 OF 65

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.

creating a presentation with the data

offering insights into the business problemCorrect Answer

redefining the business problem

collecting data relevant to the business problem

QUESTION 56 OF 65

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.

paste

export

importCorrect Answer

QUESTION 57 OF 65

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?

Replace the row with the average values of the other data points.

Sort the spreadsheet so the row with missing data is at the bottom.

Investigate previous projects and see how this was dealt with there.Correct Answer

Delete the row with the missing data point.

QUESTION 58 OF 65

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

an attributeCorrect Answer

a title

a reference

an observation

QUESTION 59 OF 65

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.

prediction

finding

record

slideshowCorrect Answer

QUESTION 60 OF 65

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.

downloadCorrect Answer

copy and paste

QUESTION 61 OF 65

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?

WHERE = 81137

zip_code = 81137

WHERE zip_code = 81137Correct Answer

WHERE_zip_code = 81137

QUESTION 62 OF 65

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?

The patients all live in the same city.

The patients all live in houses.

The patients all live in the same country.

The patients all live in the same zip code.Correct Answer

QUESTION 63 OF 65

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

subject-matter expertsCorrect Answer

customers

data scientists

stakeholders

QUESTION 64 OF 65

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.

True

FalseCorrect Answer

QUESTION 65 OF 65

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.

observation

number

qualityCorrect Answer

collection

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

Reports that predict the success of sales leads to secure future subscribers

Reports that describe 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

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?