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. A response code at or above 400 counts as a failure. For each endpoint that has accumulated more than two such failures, show the endpoint, the total number of failures, and the typical response time across those failed calls. List from the most failure-prone endpoint to the least.
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