System designHardsd-g436

Subject Data warehouseLevel Senior–Staff~40 minCommon in Distributed systems interviewsIndustries Technology, Software development

Question

You run an embedded-analytics product where thousands of your customers query their own data in a shared cloud warehouse. One customer's heavy ad-hoc query or a runaway dashboard can saturate compute and slow everyone (noisy neighbor); customers also demand strict data isolation and per-tenant cost attribution for billing. Design the warehouse architecture covering tenant isolation, query resource governance, and accurate per-tenant cost accounting, and discuss the isolation-vs-efficiency trade-off.

What a strong answer looks like

Clarify scale and constraints first. Propose a clean component breakdown, then go deep on the hard parts — data model, bottlenecks, consistency, failure modes — and name the trade-offs you are making.

Learn the concepts

Narrate your design

Loading whiteboard…

Run or narrate your approach, then ask the coach.