Slow Failures
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
Timeout incidents are being traced through the api_calls log, and the calls that matter are the ones that failed and also ran longer than 200 milliseconds. Pull those calls with their endpoint, status, latency and error message.
Summary
SRE is hunting for the endpoints that fail slowly enough to burn timeouts.
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