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?

Click To Enroll in Coursera

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?

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

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

How many customers are named Mark?

Hi, Quiztudy is pleased to assist you with any study guide, certificate, or assessment test. More study guides will be published as we grow.

• Facebook_link
• Instagram_link
• YouTube_link

Subscribe to our site

Get new content delivered directly to your inbox.