Homework 1: Docker, SQL and Terraform

Practice Docker, SQL, and Terraform basics by working with taxi data and infrastructure setup.

Instructions

Deadline: 26 January 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. What's the version of pip in the python:3.13 image? (1 point)

25.3

24.3.1

24.2.1

23.3.1

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

postgres:5433

localhost:5432

db:5433

postgres:5432

db:5432

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

7,853

8,007

8,254

8,421

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

2025-11-14

2025-11-20

2025-11-23

2025-11-25

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

East Harlem North

East Harlem South

Morningside Heights

Forest Hills

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? (1 point)

JFK Airport

Yorkville West

East Harlem North

LaGuardia Airport

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? (1 point)

terraform import, terraform apply -y, terraform destroy

teraform init, terraform plan -auto-apply, terraform rm

terraform init, terraform run -auto-approve, terraform destroy

terraform init, terraform apply -auto-approve, terraform destroy

terraform import, terraform apply -y, terraform rm