Homework 2: Workflow Orchestration

Build and run an orchestrated data workflow for loading and transforming taxi data.

Instructions

Deadline: 2 February 2026, 23:59

Shown in your timezone.

View public statistics

Correct answers are available below

This homework has already been scored. Log in to view your own submission, score, and feedback.

Correct answers

Review the expected answers for this scored homework.

1. Within the execution for Yellow Taxi data for the year 2020 and month 12: what is the uncompressed file size (i.e. the output file yellow_tripdata_2020-12.csv of the extract task)? (1 point)

128.3 MiB

134.5 MiB

364.7 MiB

692.6 MiB

2. What is the rendered value of the variable file when the inputs taxi is set to green, year is set to 2020, and month is set to 04 during execution? (1 point)

{{inputs.taxi}}_tripdata_{{inputs.year}}-{{inputs.month}}.csv

green_tripdata_2020-04.csv

green_tripdata_04_2020.csv

green_tripdata_2020.csv

3. How many rows are there for the Yellow Taxi data for all CSV files in the year 2020? (1 point)

13,537.299

24,648,499

18,324,219

29,430,127

4. How many rows are there for the Green Taxi data for all CSV files in the year 2020? (1 point)

5,327,301

936,199

1,734,051

1,342,034

5. How many rows are there for the Yellow Taxi data for the March 2021 CSV file? (1 point)

1,428,092

706,911

1,925,152

2,561,031

6. How would you configure the timezone to New York in a Schedule trigger? (1 point)

Add a timezone property set to EST in the Schedule trigger configuration

Add a timezone property set to America/New_York in the Schedule trigger configuration

Add a timezone property set to UTC-5 in the Schedule trigger configuration

Add a location property set to New_York in the Schedule trigger configuration