Course Management

Homework 3: Data Warehouse for Data Engineering Zoomcamp 2024

This homework is already scored. You didn't submit your answers.

Homework: https://github.com/DataTalksClub/data-engineering-zoomcamp/blob/main/cohorts/2024/03-data-warehouse/homework.md

Due date: 2024-02-14T23:00:00+00:00 (local time)

Please log in to submit your answers.

Question 1. What is count of records for the 2022 Green Taxi Data? (1 point)

65 623 481

840 402

1 936 423

253 647

Question 2. What is the estimated amount of data in the tables? (1 point)

0 MB for the External Table and 6.41MB for the Materialized Table

18.82 MB for the External Table and 47.60 MB for the Materialized Table

0 MB for the External Table and 0MB for the Materialized Table

2.14 MB for the External Table and 0MB for the Materialized Table

Question 3. How many records have a fare_amount of 0? (1 point)

12 488

128 219

112

1 622

Question 4. What is the best strategy to make an optimized table in Big Query? (1 point)

Cluster on lpep_pickup_datetime Partition by PUlocationID

Partition by lpep_pickup_datetime Cluster on PUlocationID

Partition by lpep_pickup_datetime and Partition by PUlocationID

Cluster on by lpep_pickup_datetime and Cluster on PUlocationID

Question 5. What's the size of the tables? (1 point)

22.82 MB for non-partitioned table and 647.87 MB for the partitioned table

12.82 MB for non-partitioned table and 1.12 MB for the partitioned table

5.63 MB for non-partitioned table and 0 MB for the partitioned table

10.31 MB for non-partitioned table and 10.31 MB for the partitioned table

Question 6. Where is the data stored in the External Table you created? (1 point)

Big Query

GCP Bucket

Big Table

Container Registry

Question 7. It is best practice in Big Query to always cluster your data (1 point)

True

False

Homework URL

Please provide a valid URL.

Learning in public links (optional)

Time spent on lectures (hours) (optional)

Time spent on homework (hours) (optional)

Problems or comments (optional)

FAQ contribution (FAQ document, optional)