Data Engineering Zoomcamp 2024

Homework 4: Analytics Engineering Statistics

Distribution of scores and reported study time for this homework.

Submissions

507

Median total score

5

Average total score

5

Score distribution

All values are points.

Questions score

Min
-
Median
5.0
Max
6
Q1
3.0
Avg
4.4
Q3
6.0

Learning in public score

Min
-
Median
0.0
Max
7
Q1
0.0
Avg
0.7
Q3
1.0

Total score

Min
-
Median
5.0
Max
14
Q1
4.0
Avg
5.1
Q3
6.0

Time distribution

All values are hours reported by students.

Lectures

Min
0.0
Median
6.0
Max
60.0
Q1
4.0
Avg
9.0
Q3
10.0

Homework

Min
1.0
Median
4.0
Max
48.0
Q1
3.0
Avg
5.9
Q3
8.0

Question breakdown

Correctness and answer distribution per question.

1. Dbt build

306 / 507 correct (60.4%)

1 It's the same as running dbt build 82 (16.2%)
2 It applies a limit 100 to all of our models 109 (21.5%)
3 It applies a limit 100 only to our staging models 307 (60.6%)
4 Nothing 8 (1.6%)

2. Code for the CI job

334 / 507 correct (65.9%)

1 The code that has been merged into the main branch 77 (15.2%)
2 The code that is behind the object on the dbt_cloud_pr_ schema 62 (12.2%)
3 The code from any development branch that has been opened based on main 28 (5.5%)
4 The code from a development branch requesting a merge to main 336 (66.3%)

3. Count of records in fhv trips

383 / 507 correct (75.5%)

1 12998722 30 (5.9%)
2 22998722 385 (75.9%)
3 32998722 21 (4.1%)
4 42998722 60 (11.8%)

4. Service with the most rides

401 / 507 correct (79.1%)

1 FHV 46 (9.1%)
2 Green 28 (5.5%)
3 Yellow 402 (79.3%)
4 FHV and Green 18 (3.6%)

Calculated: 13 October 2024, 17:46