Errors With Service Health
An easy 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
- easy
- Seniority
- L3
Interview Prompt
We keep an error-tracking log and a service-health table, both keyed by service name. For each error, attach its service's status, latency, and uptime, returning the error ID, type, message, service name, severity, count, and first occurrence alongside those three health fields.
Summary
Error data, enriched with health context.
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