The Noise Floor
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
- mid
Interview Prompt
A reliability team is separating services that page on genuine emergencies from those that mostly cry wolf, where a real emergency is a critical-severity alert. For each service report the share of its alerts that are high or critical, and surface only the services whose paging is dominated by criticals.
Summary
Not every alert deserves a 3 a.m. page. Find the services where most of them claim they do.
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