Noisy Endpoints
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L3
Interview Prompt
The SRE team is triaging an incident and needs a quick view of which API endpoints are generating the most error traffic. For each endpoint, show the endpoint, its total number of failed calls, and the typical response time across those failed calls, most failure-prone first.
Summary
The routes generating the most noise.
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