Prepare Data for Exploration Course Challenge Answers (Part 3: Q21–25)

This is Part 3 of the Module 6 quiz answers for “Prepare Data for Exploration Course Challeng” from the Google Data Analytics Professional Certificate on Coursera.

Here, we’ll walk through questions 21 to 25 with detailed explanations to support your learning.

To find answers to the remaining questions, check out the full module breakdown below:

21. 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 locate useful external data?

  • Other financial businesses ✅
  • Sewati Financial Solutions marketing department
  • Government sources ✅
  • A professional finance association ✅

Explanation:
External data is any data collected from outside your organization. It can help you understand industry trends or compare performance. Government sources, other companies, and professional associations often provide reliable and publicly accessible data. The company’s own marketing department would be considered internal data, not external.

22. Scenario 2 continued

Consider and respond to the following question.

Our analysts often work within the same spreadsheet, but for different purposes. How could filtering help in this situation?

  • Filtering enables you to highlight the header row
  • Filtering enables you to sort the data in a meaningful order
  • Filtering simplifies a spreadsheet by only showing you the information you need ✅
  • Filtering encrypts the spreadsheet so only you can access it

Explanation:
 Filtering allows users to view only relevant data in a spreadsheet, which is particularly helpful for team members working on different aspects of the same dataset.

23. Scenario 1 continued

Now that you’re familiar with the data, you want to build trust with the team at Garden.

What data-security measures do you employ? Select all that apply.

  • Add passwords to files ✅
  • Make personal copies of client files
  • Assign user permissions for files ✅
  • Change their file naming conventions

Explanation:
 Password protection and user permissions ensure that data access is restricted to authorized individuals, safeguarding client information. Personal copies of files or unnecessary changes to file-naming conventions do not contribute to data security.

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

Click below to read the email:

And click below to access the 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 is first-party data, which means that it was collected from outside sources.

  • True
  • False ✅

Explanation:
First-party data refers to information collected directly by an organization from its customers or users. In this scenario, the data was collected by the restaurant itself (Garden), not from outside sources.

25. 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 with the last name Hassan from the Clients table in our database?

Explanation:
This SQL command selects all columns (*) from the “Clients” table where the “last_name” column matches ‘Hassan’. Using the WHERE clause specifies the condition for filtering data.

Part 2 (Q11–20)

Congratulations! You’ve completed all questions. Share this post if it helped you, and check out other Coursera quiz answers below.

Related contents:

Module 1: Data types and structures
Module 2: Data responsibility
Module 3: Database essentials
Module 4: Organize and protect data

You might also like:

Course 1: Foundations: Data, Data, Everywhere
Course 2: Ask Questions to Make Data-Driven Decisions
Course 4: Process Data from Dirty to Clean
Course 5: Analyze Data to Answer Questions
Course 6: Share Data Through the Art of Visualization
Course 7: Data Analysis with R Programming
Course 8: Google Data Analytics Capstone: Complete a Case Study

Leave a Reply