Airbnb·Software Engineer·Onsite - System Design / Architecture
- Design a dashboard that lets a host see total nights booked and average nightly price across all their listings for any date range they pick, with the UI responding in under 200ms.
- How would you handle the tradeoff between data freshness and query latency in this system?
- Walk through the caching strategy you'd use for this dashboard, including how you'd handle cache misses and eviction.
- How would you model the data to support both a per-host aggregate view and a per-listing breakdown without running expensive queries each time?
“This is where I spent most of the interview.”