11. Think about data as driving a taxi cab. In this metaphor, which of the following are examples of metadata? Select all that apply.
- Company that owns the taxi
- License plate number
- Make and model of the taxi cab
- Passengers the taxi picks up
12. Fill in the blank: Data governance is the process of ensuring that a company’s _____ are managed in a formal manner.
- business tasks
- data engineers
- data assets
- business strategies
13. What are some key benefits of using external data? Select all that apply.
- External data is always reliable.
- External data is free to use.
- External data has broad reach.
- External data can provide industry-level perspectives.
14. A data analyst reviews a national database of movie theater showings. They want to find the first movies shown in San Francisco in 2001. How can they organize the data to return the first 10 movies shown at the top of their list? Select all that apply.
- Filter out showings not in 2001
- Sort by date in descending order
- Sort by date in ascending order
- Filter out showings outside of San Francisco
15. You are working with a database table that contains customer data. The state column lists the state where each customer is located. The state names are abbreviated. You want to find out which customers are located in the state of Florida (FL).
You write the SQL query below. Add a WHERE clause that will return only customers located in FL.
How many customers are located in FL?
- 6
- 4
- 1
- 3
16. Structural metadata indicates how a piece of data is organized and whether it’s part of one or more than one data collection.
- True
- False
17. Relational databases illustrate relationships between tables. Which fields represent the connection between these tables? Select all that apply.
- Foreign keys
- External keys
- Primary keys
- Secondary keys
18. When writing a query, you must remove the two backticks around the name of the dataset in order for the query to run properly.
- True
- False
Shuffle Q/A 2
19. You are working with a database table that contains customer data. The first_name column lists the first name of each customer. You are only interested in customers with the first name Mark.
You write the SQL query below. Add a WHERE clause that will return only customers named Mark.
How many customers are named Mark?
- 1
- 5
- 3
- 2
20. Metadata is data about data. What kinds of information can metadata offer about a particular dataset? Select all that apply.
- How to combine the data with another dataset
- Which analyses to perform on the data
- If the data is clean and reliable
- What kinds of data it contains
