Data Engineering Zoomcamp 2025

Homework 1: Docker, SQL and Terraform Statistics

Distribution of scores and reported study time for this homework.

Submissions

1099

Median total score

6

Average total score

6

Score distribution

All values are points.

Questions score

Min
-
Median
6.0
Max
7
Q1
5.0
Avg
5.8
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
6.0
Max
15
Q1
5.5
Avg
6.3
Q3
7.0

Time distribution

All values are hours reported by students.

Lectures

Min
0.0
Median
8.0
Max
100.0
Q1
4.0
Avg
11.3
Q3
15.0

Homework

Min
0.0
Median
4.0
Max
100.0
Q1
2.0
Avg
5.2
Q3
5.0

Question breakdown

Correctness and answer distribution per question.

1. Version of pip

1018 / 1102 correct (92.4%)

1 24.3.1 1021 (92.6%)
2 24.2.1 26 (2.4%)
3 23.3.1 36 (3.3%)
4 23.2.1 11 (1.0%)

2. Docker networking and docker-compose

862 / 1102 correct (78.2%)

1 postgres:5433 71 (6.4%)
2 localhost:5432 58 (5.3%)
3 db:5433 101 (9.2%)
4 postgres:5432 240 (21.8%)
5 db:5432 624 (56.6%)

3. Trip Segmentation Count

631 / 1102 correct (57.3%)

1 104,802; 197,670; 110,612; 27,831; 35,281 28 (2.5%)
2 104,802; 198,924; 109,603; 27,678; 35,189 634 (57.5%)
3 104,793; 201,407; 110,612; 27,831; 35,281 46 (4.2%)
4 104,793; 202,661; 109,603; 27,678; 35,189 21 (1.9%)
5 104,838; 199,013; 109,645; 27,688; 35,202 347 (31.5%)

4. Longest trip

966 / 1102 correct (87.7%)

1 2019-10-11 62 (5.6%)
2 2019-10-24 20 (1.8%)
3 2019-10-26 31 (2.8%)
4 2019-10-31 969 (87.9%)

5. Biggest pickup zones

1018 / 1102 correct (92.4%)

1 East Harlem North, East Harlem South, Morningside Heights 1020 (92.6%)
2 East Harlem North, Morningside Heights 29 (2.6%)
3 Morningside Heights, Astoria Park, East Harlem South 15 (1.4%)
4 Bedford, East Harlem North, Astoria Park 7 (0.6%)

6. Largest tip

928 / 1102 correct (84.2%)

1 Yorkville West 26 (2.4%)
2 JFK Airport 931 (84.5%)
3 East Harlem North 72 (6.5%)
4 East Harlem South 47 (4.3%)

7. Terraform

970 / 1102 correct (88.0%)

1 terraform import, terraform apply -y, terraform destroy 20 (1.8%)
2 teraform init, terraform plan -auto-apply, terraform rm 38 (3.4%)
3 terraform init, terraform run -auto-approve, terraform destroy 39 (3.5%)
4 terraform init, terraform apply -auto-approve, terraform destroy 973 (88.3%)
5 terraform import, terraform apply -y, terraform rm 7 (0.6%)

Calculated: 30 January 2025, 09:42