Prepare Data for Exploration Course Challenge Answers (Part 1: Q1–10)
Looking for ‘Prepare data for exploration course challenge answers’?
In this post, I provide accurate answers and detailed explanations for Module 6: *Course challenge* of Course 3: Prepare Data for Exploration – Google Data Analytics Professional Certificate.
Whether you’re preparing for quizzes or brushing up on your knowledge, these insights will help you master the concepts effectively. Let’s dive into the correct answers and detailed explanations for each question.
Here, we’ll walk through questions 1 to 10 with detailed explanations to support your learning.
To find answers to the remaining questions, check out the full module breakdown below:
1. Scenario 1, questions 1-5
You’ve been working at a data analytics consulting company for the past six months. Your team helps restaurants use their data to better understand customer preferences and identify opportunities to become more profitable.
To do this, your team analyzes customer feedback to improve restaurant performance. You use data to help restaurants make better staffing decisions and drive customer loyalty. Your analysis can even track the number of times a customer requests a new dish or ingredient in order to revise restaurant menus.
Currently, you’re working with a vegetarian sandwich restaurant called Garden. The owner wants to make food deliveries more efficient and profitable. To accomplish this goal, your team will use delivery data to better understand when orders leave Garden, when they get to the customer, and overall customer satisfaction with the orders.
Before project kickoff, you attend a discovery session with the vice president of customer experience at Garden. He shares information to help your team better understand the business and project objectives. As a follow-up, he sends you an email with datasets.
Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data was collected by Garden employees using their own resources. What type of data does this describe?
- Third-party data
- First-party data ✅
- Nominal data
- Qualitative data
Explanation:
First-party data is data collected directly by a business from its own customers or operations. Since Garden employees collected the data using their own resources, it qualifies as first-party data.
- Third-party data is collected by an external organization.
- Nominal and qualitative refer to types of data, not the source.
2. Scenario 1 continued
Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction survey data, click the link below and select “Use Template.”
Link to template: Customer Satisfaction Survey data
OR
If you don’t have a Google account, download the CSV file directly from the attachment below.
The question in column E asks, “Was your order accurate? Please respond yes or no.” The responses listed in column E are an example of Boolean data.
- True ✅
- False
Explanation:
Boolean data has only two possible values, like “Yes” or “No.” Since this survey question only allows one of two responses, it’s Boolean.
3. Scenario 1 continued
Now, you review the data on delivery times and the distance of customers from the restaurant.
To use the template for the dataset, click the link below and select “Use Template.”
Link to template: Delivery Times/Distance
OR
If you don’t have a Google account, download the CSV file directly from the attachment below.
The data in column E shows the duration of deliveries from Garden to customers. What type of data is this? Select all that apply.
- Continuous data
- Quantitative data ✅
- Qualitative data
- Discrete data ✅
Explanation:
- Quantitative data involves numbers and measurements.
- Discrete data is countable, like how many minutes a delivery took (often measured in whole numbers).
4. Scenario 1 continued
The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. This is an example of structured data.
- True
- False ✅
Explanation:
Structured data is neatly organized in rows and columns (like spreadsheets).
Pictures are unstructured because they don’t follow a defined data model.
5. Scenario 1 continued
Now that you’re familiar with the data, you want to build trust with the team at Garden. You decide to impress them by taking the initiative to reach out to your social media followers. You explain that Garden is a new client, and you show them the pictures of Garden’s sandwich deliveries from the client file. Then, you ask them if they have any photos of sandwich deliveries that you can evaluate.
This is an example of going above and beyond expectations and a great way to build trust.
- True
- False ✅
Explanation:
Sharing client data (even images) without permission violates privacy and breaks trust. Even if it seems like initiative, it’s unethical and unprofessional.
6. Scenario 2, questions 6-10
You’ve completed this program and are interviewing for a junior data scientist position at a company called Sewati Financial Services.
So far, you’ve successfully completed the first interview with a recruiter. They arrange your second interview with the team at Sewati Financial Services.
You arrive 15 minutes early for your interview. Soon, you are escorted into a conference room, where you meet Kai Harvey, the senior manager of strategy. After welcoming you, he begins the behavioral interview.
Consider and respond to the following question. Select all that apply.
Our data analytics team often surveys clients to get their feedback. If you were on the team, how would you ensure the process does not cause potential bias?
- Make sure the wording of the survey question does not encourage a specific response from participants. ✅
- Include clients with disabilities in the survey sample. ✅
- Give participants enough time to answer each survey question. ✅
- Instruct participants to share their name and contact information.
Explanation:
Avoiding bias involves fair question phrasing, allowing adequate response time, and ensuring the survey is inclusive and representative of the target audience.
7. Scenario 2 continued
Consider and respond to the following question. Select all that apply.
Our data analytics team often uses external data. Where can you access useful external data?
- A public database ✅
- An open-data website ✅
- Sewati Financial Services database in the cloud
- Sewati Financial Services website
Explanation:
External data sources like public databases and open-data websites are reliable platforms for accessing data not generated internally by an organization.
8. Scenario 2 continued
Consider and respond to the following question. Select all that apply.
Our analysts often work within the same spreadsheet, but for different purposes. What tools would you use in such a situation?
- Freeze the header rows ✅
- Sort the data to make it easier to understand, analyze, and visualize ✅
- Filter to show only the data that meets a specific criteria ✅
- Encrypt the spreadsheet so only you can access it
Explanation:
These tools help organize and navigate shared spreadsheets.
Encryption is about security—not collaboration.
9. Scenario 2 continued
Next, your interviewer wants to better understand your knowledge of basic SQL commands. He asks: How would you write a query that retrieves only data about people who work in Boise from the Clients table in our database?
Explanation:
This retrieves records from the Clients table where the City column has the value ‘Boise’.
10. Scenario 2 continued
For your final question, your interviewer explains that Sewati Financial Services cares about data privacy. The company needs its clients’ trust, and this is an important responsibility for the data analytics team.
He asks: What does data privacy involve? Select all that apply.
- Encryption and sharing permissions
- Preserving a data subject’s information and activity any time a data transaction occurs ✅
- Putting privacy measures in place to protect people’s data ✅
- A person’s legal right to their data ✅
Explanation:
Data privacy includes:
- Ensuring people’s data is used ethically
- Complying with laws like GDPR
- Getting consent and applying security measures
- Encryption is a privacy tool, but not the entire concept
That’s it for Part 1! Continue your learning journey with the next set of answers.
Next Part: Prepare Data for Exploration Course Challenge Answers (Part 2: Q11–20)