Design a service where users upload CSV files of up to several gigabytes, and the service validates them and loads them into PostgreSQL. How would you build it in Python?
~10 min by voice
How to approach it
They're checking whether the candidate understands that a gigabyte-sized file can't be processed synchronously or fully in memory: you need an asynchronous design with a background task, streaming reads, batch inserts and a well-thought-out strategy for errors and atomicity.
The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.