Course Management

Homework 4: Analytics Engineering for Data Engineering Zoomcamp 2026

This homework is already scored. Log in to see your submission.

Due date: 2026-02-16T23:59:59+00:00 (local time)

Please log in to access this homework.

Question 1. Q1: dbt run --select int_trips_unioned builds which models? (1 point)

stg_green_tripdata, stg_yellow_tripdata, and int_trips_unioned

Any model with upstream and downstream dependencies

int_trips_unioned only

int_trips_unioned, int_trips, and fct_trips

Question 2. Q2: New value 6 appears in payment_type. What happens on dbt test? (1 point)

dbt skips the test

dbt fails the test with non-zero exit code

dbt passes with warning

dbt updates the configuration

Question 3. Q3: Count of records in fct_monthly_zone_revenue? (1 point)

12,998

14,120

12,184

15,421

Question 4. Q4: Zone with highest revenue for Green taxis in 2020? (1 point)

East Harlem North

Morningside Heights

East Harlem South

Washington Heights South

Question 5. Q5: Total trips for Green taxis in October 2019? (1 point)

500,234

350,891

384,624

421,509

Question 6. Q6: Count of records in stg_fhv_tripdata (filter dispatching_base_num IS NULL)? (1 point)

42,084,899

43,244,693

22,998,722

44,112,187

Homework URL

Please provide a valid URL.

Learning in public links (optional)

Time spent on lectures (hours) (optional)

Time spent on homework (hours) (optional)

FAQ contribution (FAQ document, optional)

Status: Not submitted