Incident Keyword Messages
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
During an incident review, the on-call engineer needs to find chat messages containing the words 'latency', 'down', 'back', or 'pipeline' and match them with error tracking entries from the same month. For each matching message, pull the associated severity. Show the channel, message content, and severity.
Summary
Certain words trigger an investigation.
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