System design interview question
"Design an ingestion service that takes roughly 200 GB of data per run from an external partner and loads it into our warehouse. The requirement is that not one record may be lost or silently corrupted — this feeds financial reporting. Runs fail partway through: the network drops, the partner's file is truncated, our workers crash."
the difference between claiming losslessness and proving it. Any pipeline can be described as reliable; the discriminating answer builds verification that would detect loss, designs for resumption without duplication, and treats reconciliation as the deliverable rather than a nice-to-have.
On Practick another engineer interviews you live for 60 minutes on a question from this bank. They have the full interviewer guide beside the call: the answers to your clarifying questions, the numbers to hand out, a ladder of follow-ups and a scoring rubric. You get the model solution once the session settles. It is free: interview someone for an hour and you have earned your own.
Book a free mock interviewAll 132 system design interview questions
System design mock interviews · DSA interview questions · Free mock interview practice · Browse interviewers · Sign in