Trade-offs: Pre-aggregation vs. Querying Raw Data
Tests your grasp of data system trade-offs. A great answer weighs pre-aggregation (fast, cheap, stale) against querying raw data (slow, costly, fresh, flexible) and proposes a hybrid solution. A red flag is declaring one method universally superior.
This question tests your ability to design practical data systems by balancing competing needs. A strong answer first contrasts pre-aggregation (low latency/cost, stale data, limited flexibility) with querying raw data (high latency/cost, fresh data, full flexibility). Then, it proposes a hybrid model using pre-aggregations for common dashboard views with drill-down access to raw data for deep dives. A major red flag is failing to frame the choice as a context-dependent trade-off between performance, cost, and analytical needs.
Read the original → docs.embeddable.com
- #data engineering
- #system design
- #analytics
- #databases
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.