Data Engineering Zoomcamp 2026

Homework 1: Docker, SQL and Terraform Statistics

Distribution of scores and reported study time for this homework.

Submissions

1573

Median total score

7

Average total score

6

Score distribution

All values are points.

Questions score

Min
-
Median
7.0
Max
7
Q1
6.0
Avg
5.9
Q3
7.0

Learning in public score

Min
-
Median
0.0
Max
7
Q1
0.0
Avg
0.4
Q3
0.0

Total score

Min
-
Median
7.0
Max
15
Q1
6.0
Avg
6.3
Q3
7.0

Time distribution

All values are hours reported by students.

Lectures

Min
0.0
Median
6.0
Max
168.0
Q1
4.0
Avg
9.9
Q3
10.0

Homework

Min
0.0
Median
3.0
Max
120.0
Q1
2.0
Avg
5.0
Q3
6.0

Question breakdown

Correctness and answer distribution per question.

1. What's the version of pip in the python:3.13 image?

1394 / 1578 correct (88.3%)

1 25.3 1398 (88.6%)
2 24.3.1 131 (8.3%)
3 24.2.1 27 (1.7%)
4 23.3.1 11 (0.7%)

2. Given the docker-compose.yaml, what is the hostname and port that pgadmin should use to connect to the postgres database?

1305 / 1578 correct (82.7%)

1 postgres:5433 65 (4.1%)
2 localhost:5432 101 (6.4%)
3 db:5433 90 (5.7%)
4 postgres:5432 351 (22.2%)
5 db:5432 958 (60.7%)

3. For the trips in November 2025, how many trips had a trip_distance of less than or equal to 1 mile?

1370 / 1578 correct (86.8%)

1 7,853 33 (2.1%)
2 8,007 1371 (86.9%)
3 8,254 99 (6.3%)
4 8,421 40 (2.5%)

4. Which was the pick up day with the longest trip distance? Only consider trips with trip_distance less than 100 miles.

1245 / 1578 correct (78.9%)

1 2025-11-14 1246 (79.0%)
2 2025-11-20 123 (7.8%)
3 2025-11-23 131 (8.3%)
4 2025-11-25 40 (2.5%)

5. Which was the pickup zone with the largest total_amount (sum of all trips) on November 18th, 2025?

1403 / 1578 correct (88.9%)

1 East Harlem North 1406 (89.1%)
2 East Harlem South 73 (4.6%)
3 Morningside Heights 33 (2.1%)
4 Forest Hills 22 (1.4%)

6. For the passengers picked up in the zone named "East Harlem North" in November 2025, which was the drop off zone that had the largest tip?

1171 / 1578 correct (74.2%)

1 JFK Airport 174 (11.0%)
2 Yorkville West 1174 (74.4%)
3 East Harlem North 111 (7.0%)
4 LaGuardia Airport 70 (4.4%)

7. Which of the following sequences describes the Terraform workflow for: 1) Downloading plugins and setting up backend, 2) Generating and executing changes, 3) Removing all resources?

1413 / 1578 correct (89.5%)

1 terraform import, terraform apply -y, terraform destroy 19 (1.2%)
2 teraform init, terraform plan -auto-apply, terraform rm 39 (2.5%)
3 terraform init, terraform run -auto-approve, terraform destroy 52 (3.3%)
4 terraform init, terraform apply -auto-approve, terraform destroy 1415 (89.7%)
5 terraform import, terraform apply -y, terraform rm 14 (0.9%)

Calculated: 29 January 2026, 19:31