21. 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.
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-27-at-1.08.35-PM.png)
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
22. 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.
23. 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.
24. The words rank, name, population, and county in row 1 of the following spreadsheet are known as descriptors.
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-27-at-1.17.02-PM.png)
- True
- False
25. Fill in the blank: In the following spreadsheet, the ________ of High Point describes all of the data in row 10.
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-27-at-1.19.03-PM.png)
- criteria
- dataset
- observation
- format
26. If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B?
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-27-at-1.20.40-PM.png)
- Sort range
- Name range
- Randomize range
- Organize range
27. 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
28. 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
Shuffle Q/A 3
29. 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.
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-05-25-at-9.47.48-AM.png)
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
30. 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