Feature Name Intersection
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L4
Interview Prompt
Our ML feature store ingests the same feature names from many upstream feeds, and we're auditing the ones flowing in from both the 'ad_impressions' and 'search_queries' sources. For each feature name present in both, return its name along with how many rows came from each of those two sources and the most recent update date in each.
Summary
Training names versus serving names. The overlap.
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