Your question is End-to-End Pipeline Design. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Explain the process of pipeline design end to end.
Cover how you gather requirements, select batch or streaming patterns, ingest and transform data, model and store outputs, orchestrate dependencies, validate quality, monitor operations, handle failures, and support backfills. Discuss how you would make the design idempotent, observable, secure, cost-effective, and maintainable as data volume and schema complexity grow.