Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Schema and Daily Ingestion Design

HardPipelines00:00
Practice interviewer
In session
5 left
00:00

Your question is Schema and Daily Ingestion 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).

You need to log in / sign up to chat or submit.

Problem

Design a data schema for an online exercise app and design the data system to support daily data ingestion.

Define entities such as users, exercises, workouts, attempts, and measurements, including keys, relationships, constraints, and indexing choices. Describe a production-ready daily batch pipeline, including source extraction, raw and curated storage, incremental processing, data-quality checks, orchestration, observability, retries, idempotency, and backfill handling. Provide the schema and pipeline design using concrete technologies and explain important trade-offs.