Where Quality Breaks
An easy SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
Each row of `dq_checks` is one quality check run against a source table, with `passed` recording whether it flagged a problem and `fail_pct` the share of values that failed. Looking only at the flagged checks, surface the source tables with the worst average fail percentage, with how many flagged checks each has and how many different rules they involved.
Summary
Which tables the checks keep flagging.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision