Module 4: Become a Fair and Impactful Data Professional Answers (Part 3: Q31–45)
This is Part 3 of the Module 1 quiz answers for “Become a Fair and Impactful Data Professional” from the Google Data Analytics Professional Certificate on Coursera.
Here, we’ll walk through questions 31 to 45 with detailed explanations to support your learning.
To find answers to the remaining questions, check out the full module breakdown below:
31. You are working with a database table named playlist that contains data about playlists for different types of digital media. You want to review all the columns in the table.
You write the SQL query below. Add a FROM clause that will retrieve the data from the playlist table.
What is the playlist with ID number 3?
- Audiobooks
- Music
- Movies
- TV Shows ✅
Explanation:
You’d use SELECT * FROM playlist; then look for the row where playlist_id = 3.
32. You are working with a database table that contains invoice data. The customer_id column lists the ID number for each customer. You are interested in invoice data for the customer with ID number 28.
You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 28.
After you run your query, use the slider to view all the data presented.
What is the billing city for the customer with ID number 28?
- Bangalore
- Buenos Aires
- Dijon
- Salt Lake City ✅
Explanation:
Use SELECT * FROM invoice WHERE customer_id = 28; and check the billing_city field.
33. Which of the following best describes a bar chart?
- It is a visualization that uses a circle which is divided into wedges sized based on numerical proportion.
- It is a visualization that plots a sequence of points and connects them with them with straight lines or curves.
- It is a visualization that represents data with columns, or bars, the heights of which are proportional to the values that they represent. ✅
- It is a visualization that plots individual points in the Cartesian coordinate plane.
Explanation:
Bar charts are ideal for comparing categories or discrete values.
34. A data analyst has to create a visualization that clearly shows when and for how long the population of Charlotte has been above one million people. They choose to use a line chart. Why is this the best choice for their visualization?
- It is a visualization that plots a sequence of points and connects them with straight lines or curves. ✅
- It is a visualization that uses a circle which is divided into wedges sized based on numerical proportion.
- It is a visualization that represents data with columns, or bars, the heights of which are proportional to the values that they represent.
- It is a visualization that plots individual points in the Cartesian coordinate plane.
Explanation:
Line charts show trends and time-based changes effectively.
35. The words rank, name, population, and county in row 1 of the following spreadsheet are known as descriptors.
- True
- False ✅
Explanation:
They’re actually attributes or column headers, not descriptors.
36. Fill in the blank: In the following spreadsheet, the ________ of High Point describes all of the data in row 10.
- criteria
- dataset
- observation ✅
- format
Explanation:
An observation refers to a single record or data entry, which in this case is the entire row containing details about “High Point.”
37. If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B?
- Sort range ✅
- Name range
- Randomize range
- Organize range
Explanation:
Sort range allows sorting data alphabetically or numerically by selected columns.
38. A data analyst wants to create a visualization that depicts the populations of the top ten most populous cities in North Carolina. What type of chart would be best for this?
- A pie chart
- A scatter chart
- A column, or bar, chart ✅
- A line chart
Explanation:
Ideal for comparing quantities between categories like city names.
39. A data analyst has to demonstrate a trend of how something has changed over time. What type of chart is best for this task?
- Line ✅
- Area
- Bar
- Column
Explanation:
Designed specifically to display trends over time.
40. You are working with a database table that contains invoice data. The customer_id column lists the ID number for each customer. You are interested in invoice data for the customer with ID number 54.
You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 54.
After you run your query, use the slider to view all the data presented.
What is the billing address for the customer with ID number 54?
- 1033 N Park Ave
- 230 Elgin St
- 110 Raeburn Pl ✅
- 801 W 4th St
Explanation:
Use SQL to filter WHERE customer_id = 54 and read the billing_address field.
41. Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the ____ feature to change it to a column chart.
- chart editor ✅
- rename
- filter view
- image
Explanation:
The Chart editor lets users customize and switch chart types easily.
42. You are working with a database table named employee that contains data about employees. You want to review all the columns in the table.
You write the SQL query below. Add a FROM clause that will retrieve the data from the employee table.
What is the job title of Andrew Adams?
- General Manager ✅
- Sales Manager
- Sales Support Agent
- IT Manager
Explanation:
SQL query: SELECT * FROM employee; then locate the entry for Andrew Adams.
43. Fill in the blank: Suppose you wanted to determine the average population of the cities in the following spreadsheet. The correct function syntax to use would be ________ .
- =AVERAGE(C2-C11)
- AVERAGE(D2:D11)
- AVERAGE(C2:C11)
- =AVERAGE(C2:C11) ✅
Explanation:
The AVERAGE function calculates the mean of the values in the specified range. Here, C2:C11 includes all the population values.
44. A data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically. They can use the feature sort range to do this.
- True ✅
- False
Explanation:
Accurate—“Sort range” is used for alphabetizing text data in columns.
45. In the following spreadsheet, the observation of Greensboro describes all of the data in row 4.
- True ✅
- False
Explanation:
A row representing one city is an observation.
Hope this helped! Use the buttons below to move to the previous or next part.