Course Management

1. Model resolution (1 point)

select * from dtc_zoomcamp_2025.raw_nyc_tripdata.ext_green_taxi

select * from dtc_zoomcamp_2025.my_nyc_tripdata.ext_green_taxi

select * from myproject.raw_nyc_tripdata.ext_green_taxi

select * from myproject.my_nyc_tripdata.ext_green_taxi

select * from dtc_zoomcamp_2025.raw_nyc_tripdata.green_taxi

2. Change the query (1 point)

Add ORDER BY pickup_datetime DESC and LIMIT {{ var("days_back", 30) }}

Update the WHERE clause to pickup_datetime >= CURRENT_DATE - INTERVAL '{{ var("days_back", 30) }}' DAY

Update the WHERE clause to pickup_datetime >= CURRENT_DATE - INTERVAL '{{ env_var("DAYS_BACK", "30") }}' DAY

Update the WHERE clause to pickup_datetime >= CURRENT_DATE - INTERVAL '{{ var("days_back", env_var("DAYS_BACK", "30")) }}' DAY

Update the WHERE clause to pickup_datetime >= CURRENT_DATE - INTERVAL '{{ env_var("DAYS_BACK", var("days_back", "30")) }}' DAY

3. Lineage (1 point)

dbt run

dbt run --select +models/core/dim_taxi_trips.sql+ --target prod

dbt run --select +models/core/fct_taxi_monthly_zone_revenue.sql

dbt run --select +models/core/

dbt run --select models/staging/+

4. Macros and Jinja (1 point)

Setting a value for DBT_BIGQUERY_TARGET_DATASET env var is mandatory, or it'll fail to compile

Setting a value for DBT_BIGQUERY_STAGING_DATASET env var is mandatory, or it'll fail to compile

When using core, it materializes in the dataset defined in DBT_BIGQUERY_TARGET_DATASET

When using stg, it materializes in the dataset defined in DBT_BIGQUERY_STAGING_DATASET, or defaults to DBT_BIGQUERY_TARGET_DATASET

When using staging, it materializes in the dataset defined in DBT_BIGQUERY_STAGING_DATASET, or defaults to DBT_BIGQUERY_TARGET_DATASET

5. Taxi Quarterly Revenue Growth (1 point)

green: {best: 2020/Q2, worst: 2020/Q1}, yellow: {best: 2020/Q2, worst: 2020/Q1}

green: {best: 2020/Q2, worst: 2020/Q1}, yellow: {best: 2020/Q3, worst: 2020/Q4}

green: {best: 2020/Q1, worst: 2020/Q2}, yellow: {best: 2020/Q2, worst: 2020/Q1}

green: {best: 2020/Q1, worst: 2020/Q2}, yellow: {best: 2020/Q1, worst: 2020/Q2}

green: {best: 2020/Q1, worst: 2020/Q2}, yellow: {best: 2020/Q3, worst: 2020/Q4}

6. P97/P95/P90 Taxi Monthly Fare (1 point)

green: {p97: 55.0, p95: 45.0, p90: 26.5}, yellow: {p97: 52.0, p95: 37.0, p90: 25.5}

green: {p97: 55.0, p95: 45.0, p90: 26.5}, yellow: {p97: 31.5, p95: 25.5, p90: 19.0}

green: {p97: 40.0, p95: 33.0, p90: 24.5}, yellow: {p97: 52.0, p95: 37.0, p90: 25.5}

green: {p97: 40.0, p95: 33.0, p90: 24.5}, yellow: {p97: 31.5, p95: 25.5, p90: 19.0}

green: {p97: 55.0, p95: 45.0, p90: 26.5}, yellow: {p97: 52.0, p95: 25.5, p90: 19.0}

7. Top #Nth longest P90 travel time Location for FHV (2 points)

LaGuardia Airport, Chinatown, Garment District

LaGuardia Airport, Park Slope, Clinton East

LaGuardia Airport, Saint Albans, Howard Beach

LaGuardia Airport, Rosedale, Bath Beach

LaGuardia Airport, Yorkville East, Greenpoint

Homework 4: Analytics Engineering