Streaming media
Spotify interview themes
What people report studying for — not a take-home dump. Last editorial update 2026-09-12.
Rounds you should expect
SQL
30-day rolling unique listeners without scanning 30 days of raw events every night.
Warehouse
Partition filters, clustering, and a dashboard that ticks too often.
From the question bank
easy · SQL · SQL
Sessionize click events with a 30-minute inactivity gap.
Practice →medium · SQL · SQL
You grouped by DATE_TRUNC(week, ts) and compared to last week. Why are week 1 and week 53 lying?
Practice →hard · Orchestration · Airflow
A load task appends. The retry doubled yesterday. What was missing?
Practice →medium · Orchestration · Airflow
How do you rerun one day without editing start_date?
Practice →medium · Warehouse · BigQuery
A query scanned 4 TB. Name three fixes before you buy more slots.
Practice →easy · Warehouse · BigQuery
Slots vs a materialized table for a 5-minute dashboard.
Practice →medium · Warehouse · BigQuery
You clustered on customer_id and filtered WHERE country = 'US'. Why did bytes scanned barely drop?
Practice →medium · Warehouse · BigQuery
Slots are reserved; a student query still billed on-demand. How?
Practice →hard · System design · System design
Backfill two years without starving the 8:00 SLA. How?
Practice →medium · System design · System design
Design clickstream → daily active users for 50 analysts at 09:00. 5-minute lag is enough. Sketch layers and one SLA.
Practice →hard · System design · System design
Multi-region: EU data cannot leave EU, US analysts want a global dashboard. Draw the legal design.
Practice →medium · Orchestration · Dagster
Asset checks vs dbt tests. Who owns which?
Practice →