API Traffic by CDN Edge
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
- L4
Interview Prompt
The CDN team is analyzing API traffic efficiency across edge locations. For request paths that include 'api', compute the average bytes served at each edge location and path combination. Only include edge locations that have delivered at least one cache hit across any path. Return the edge location, request path, and average bytes, from lowest average to highest.
Summary
CDN paths carrying API traffic. Which edges?
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