DATABASES: WHERE DATA LIVES – INTRODUCTION

Test your knowledge on working with databases

1. Fill in the blank: A _____ is an identifier that references a database column in which each value is unique.

2. Fill in the blank: A relational database contains a series of _____ that can be connected to form relationships.

3. A key benefit of working with normalized databases is that they help lower data redundancy. Which of the following is an example of redundancy?

Test your knowledge on metaData

1. A large company has several data collections across its many departments. What kind of metadata indicates exactly how many collections a piece of data lives in?

2. The date and time a photo was taken is an example of which kind of metadata?

3. A large metropolitan high school gives each of its students an ID number to differentiate them in its database. What kind of metadata are the ID numbers?

4. A company needs to merge third-party data with its own data. Which of the following actions will help make this process successful? Select all that apply.

Test your knowledge on accessing data sources

1. A CSV file saves data in a table format. What does CSV stand for?

2. A data analyst wants to bring data from a CSV file into a spreadsheet. This is an example of what process?

3. A CSV file makes it easier for data analysts to complete which tasks? Select all that apply.

4. What is the process of showing only the data that meets a specified criteria while hiding the rest?

Test your knowledge on sorting and filtering

1. What is the process for arranging data into a meaningful order to make it easier to understand, analyze, and visualize?

2. A data analyst is reviewing a national database of real estate sales. They are only interested in sales of condominiums. How can the analyst narrow their scope?

3. A data analyst works for a rental car company. They have a spreadsheet that lists car ID numbers and the dates cars were returned. How can they sort the spreadsheet to find the most recently returned cars?

4. Fill in the blank: To keep a header row at the top of a spreadsheet, highlight the row and select _____ from the View menu.

Working with large datasets in Sql

1. Run another query on your table:

SELECT

     end_station_name

FROM

    `bigquery-public-data.london_bicycles.cycle_hire`

WHERE

     rental_id = 57635395;

At what station did the bike trip with rental_id 57635395 end?

Create a custom table in BigQuery

1. After running the query on your new table, what was the third most popular baby name for boys in 2014?

Test your knowledge on using SQL with large datasets

1. In MySQL, what is acceptable syntax for the SELECT keyword? Select all that apply.

2. A database table is named blueFlowers. What type of case is this?

3. In BigQuery, what optional syntax can be removed from the following FROM clause without stopping the query from running?

FROM `bigquery-public-data.sunroof_solar.solar_potential_by_postal_code`

4. In the following FROM clause, what is the table name in the SQL query?

FROM

bigquery-public-data.sunroof_solar.solar_potential_by_postal_code

GOOGLE DATA ANALYTICS COURSERA ANSWERS AND STUDY GUIDE

Weekly Breakdown | Google Study Guides | Back to Top

Prepare Data for Exploration Weekly Challenge 3

1. Primary and foreign keys are two connected identifiers within separate tables. These tables exist in what kind of database?

2. When working with data from an external source, what can metadata help data analysts do? Select all that apply.

3. Think about data as a student at a high school. In this metaphor, which of the following are examples of metadata? Select all that apply.

4. Fill in the blank: Data governance is the process of ensuring that a company’s _____ are managed in a formal manner.

5. What are some key benefits of using external data? Select all that apply.

6. A data analyst reviews a database of Wisconsin car sales to find the last car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars sold at the top of their list? Select all that apply.

7. When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.

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

9. How many customers are named Mark?

10. Relational databases contain a series of tables connected to form relationships. Which two types of fields exist in two connected tables?

11. Data analysts use metadata for what tasks? Select all that apply.

12. Structural metadata indicates how a piece of data is organized and whether it’s part of one or more than one data collection.

12. What is the process that data analysts use to ensure the formal management of their company’s data assets?

13. A data analyst chooses not to use external data because it represents diverse perspectives. This is an appropriate decision when working with external data.

14. A data analyst reviews a database of Wisconsin car sales to find the last car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars sold at the top of their list? Select all that apply.

15. Think about data as driving a taxi cab. In this metaphor, which of the following are examples of metadata? Select all that apply.

16. What are some key benefits of using external data? Select all that apply.

17. You are working with a database table that contains customer data. The city column lists the city where each customer is located. You want to find out which customers are located in Berlin.

You write the SQL query below. Add a WHERE clause that will return only customers located in Berlin.
SELECT
*
FROM
customer

How many customers are located in Berlin?

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

19. A nonprofit maintains a list of how many laptops they provide to each school in the county. In the table, there is a column called number_of_laptops. A data analyst wants to determine which schools were given the fewest laptops. How should they sort the data to return these schools first?

20. When writing a query, you must remove the two backticks around the name of the dataset in order for the query to run properly.

21. Fill in the blank: Data _ is the process of ensuring the formal management of a company’s data assets.

22. In what circumstance might a data analyst choose not to use external data in their analysis?

databases: where data lives – conclusion