Top Percentile API Tokens
A hard 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
- hard
- Seniority
- L5
Interview Prompt
A security reviewer suspects a handful of API tokens carry far more traffic than the rest of their permission scope. From the api_tokens table, flag the tokens at or above the 95th percentile of requests within their own scope, returning each one's token ID, scope, request count and percentile rank.
Summary
The most suspicious tokens.
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