Practice — Case Study: Design a Batch Analytics Platform (5 questions)

Northwind Retail (from the case study) just signed a partnership deal that goes live tomorrow and is expected to 10x order volume and clickstream traffic overnight — permanently, not a temporary spike. Using the concrete numbers from the case study (12,000 orders/day, 55M clickstream events/day, a ~1.5–2 hour transform critical path inside a 7:00am SLA, a 3-day rolling lookback for late data):

1. Walk through the pipeline stage by stage and identify which component breaks or degrades first at 10x volume, and why — be specific about which number crosses which threshold.
2. Propose a redesign for that first bottleneck.
3. Even if every individual component scaled linearly, what SLA or cost consequence would still need to be addressed, and how?