Homework 1: Docker, SQL and Terraform

Deadline: 26 January 2025, 23:59
Shown in your timezone.
Log in to submit this homework

You can preview the questions, but submissions are saved only for logged-in students.

Log in to submit

Questions

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

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

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

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

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

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)

7. Which of the following sequences describes the workflow for: 1) Downloading provider plugins and setting up backend, 2) Generating proposed changes and auto-executing the plan, 3) Remove all resources managed by terraform? (1 point)

Submission details

Please provide a valid URL.
Status: Not saved yet