Feature Flag Engagement Impact
A hard 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
- hard
- Seniority
- L5
Interview Prompt
The growth team wants to understand session activity around feature flag launches. Show each feature flag's name, a display name with the underscores replaced by spaces, whether the flag is currently enabled, and how many user sessions started in the 30 days after the flag was created.
Summary
Flags on versus flags off. The engagement gap.
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