Cost Share Within Category
A medium 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
- medium
- Seniority
- L4
Interview Prompt
A FinOps analyst is looking at how spend breaks down inside the compute, storage and network categories of the cost allocations. For every allocation in those categories, return its allocation ID, category, amount in whole dollars, and the percentage of its category's total spend it represents.
Summary
Each entry's slice of the category total.
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