Data Engineering Zoomcamp 2026

Homework 4: Analytics Engineering Statistics

Distribution of scores and reported study time for this homework.

Submissions

695

Median total score

Average total score

Score distribution

All values are points.

Metric	Min	Q1	Median	Average	Q3	Max
Questions score	-	4.0	5.0	4.9	6.0	6
Learning in public score	-	0.0	0.0	0.6	1.0	7
Total score	-	4.0	6.0	5.5	6.0	14

Questions score

Min: -
Median: 5.0
Max: 6
Q1: 4.0
Avg: 4.9
Q3: 6.0

Learning in public score

Min: -
Median: 0.0
Max: 7
Q1: 0.0
Avg: 0.6
Q3: 1.0

Total score

Min: -
Median: 6.0
Max: 14
Q1: 4.0
Avg: 5.5
Q3: 6.0

Time distribution

All values are hours reported by students.

Metric	Min	Q1	Median	Average	Q3	Max
Lectures	1.0	4.0	6.0	9.0	10.0	72.0
Homework	0.0	3.0	5.0	6.8	8.0	63.0

Lectures

Min: 1.0
Median: 6.0
Max: 72.0
Q1: 4.0
Avg: 9.0
Q3: 10.0

Homework

Min: 0.0
Median: 5.0
Max: 63.0
Q1: 3.0
Avg: 6.8
Q3: 8.0

Question breakdown

Correctness and answer distribution per question.

1. Q1: dbt run --select int_trips_unioned builds which models?

491 / 699 correct (70.2%)

1 stg_green_tripdata, stg_yellow_tripdata, and int_trips_unioned 186 (26.6%)

2 Any model with upstream and downstream dependencies 11 (1.6%)

3 int_trips_unioned only 494 (70.7%)

4 int_trips_unioned, int_trips, and fct_trips 7 (1.0%)

2. Q2: New value 6 appears in payment_type. What happens on dbt test?

665 / 699 correct (95.1%)

1 dbt skips the test 4 (0.6%)

2 dbt fails the test with non-zero exit code 669 (95.7%)

3 dbt passes with warning 14 (2.0%)

4 dbt updates the configuration 8 (1.1%)

3. Q3: Count of records in fct_monthly_zone_revenue?

478 / 699 correct (68.4%)

1 12,998 115 (16.5%)

2 14,120 71 (10.2%)

3 12,184 481 (68.8%)

4 15,421 17 (2.4%)

4. Q4: Zone with highest revenue for Green taxis in 2020?

611 / 699 correct (87.4%)

1 East Harlem North 614 (87.8%)

2 Morningside Heights 15 (2.1%)

3 East Harlem South 52 (7.4%)

4 Washington Heights South 5 (0.7%)

5. Q5: Total trips for Green taxis in October 2019?

559 / 699 correct (80.0%)

1 500,234 36 (5.2%)

2 350,891 30 (4.3%)

3 384,624 563 (80.5%)

4 421,509 55 (7.9%)

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

577 / 699 correct (82.5%)

1 42,084,899 40 (5.7%)

2 43,244,693 581 (83.1%)

3 22,998,722 44 (6.3%)

4 44,112,187 12 (1.7%)

Calculated: 21 February 2026, 13:52