Staff Data Engineer Elite Architecture
GoogleA New Column on a Billion Rows
Our product team needs a new column added to the orders table - which has grown to a billion rows and receives 50K writes per minute. The migration must go live next week and production availability cannot be impacted. Design the migration approach and the backfill strategy.
Ask the interviewer clarifying questions to understand the requirements and constraints before designing.
When you're ready, click Ready to Design to start building.
A New Column on a Billion Rows
A hard Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- hard
- Seniority
- staff
Interview Prompt
Our product team needs a new column added to the orders table - which has grown to a billion rows and receives 50K writes per minute. The migration must go live next week and production availability cannot be impacted. Design the migration approach and the backfill strategy.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision