Pipeline Overhead by Environment
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
The data platform team wants to compare throughput overhead between pipelines that finished successfully and those still running. For each of those two states, work out the average size of the gap between rows read in and rows written out, then report how far apart those two averages are as a single number. Status is recorded with inconsistent capitalization, so spellings like 'success' and 'Success' should be counted as the same state.
Summary
Production overhead versus staging.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision