Build a event-driven Feed Generation Pipeline
Last updated: August 31, 2025
Quick Overview
Design a event-driven feed generation system that handles millions of requests. Discuss trade-offs in consistency, availability, and performance.
Snowflake
August 31, 2025289
7
2,152 solved
Design a event-driven feed generation system that handles millions of requests. Discuss trade-offs in consistency, availability, and performance.
This is a common system design question asked during Technical Screen at Snowflake. The interviewer expects you to demonstrate your ability to design large-scale distributed systems, make well-reasoned trade-offs, and communicate your thought process clearly. Snowflake values engineers who can think about scalability from day one.
What the Interviewer Expects
- Systematically gather requirements and estimate capacity (QPS, storage, bandwidth)
- Design a scalable architecture with clear component responsibilities
- Make well-reasoned database and caching decisions with trade-off analysis
- Address consistency vs availability trade-offs specific to the use case
- Discuss partitioning strategy, replication, and data modeling
- Cover failure handling, monitoring, and alerting strategies
Key Topics to Cover
How to Approach This
- Start by clarifying functional and non-functional requirements with the interviewer.
- Estimate the scale: QPS, storage, bandwidth. This drives your design decisions.
- Draw a high-level architecture first, then deep dive into 1-2 critical components.
- Discuss trade-offs explicitly (e.g., consistency vs availability, SQL vs NoSQL).
- Address failure scenarios, monitoring, and how the system handles 10x traffic spikes.
Possible Follow-up Questions
- How would you migrate from a monolithic to a microservices architecture?
- What monitoring and alerting would you set up on day one?
- How would you handle a region-wide outage?
- How would you handle a 10x increase in traffic overnight?
Practice a Similar Problem on Codemia
Solve a related problem with our interactive workspace, get AI feedback, and view detailed solutions.
Solve on CodemiaSample Answer
Requirements
Functional Requirements
- Event Ingestion: The system must ingest events from various sources (APIs, databases, etc.) in real-time.
- Feed Generation: Generate user-specific feeds based ...
Capacity Estimation
Back-of-Envelope Calculations
- User Base: Assume 10 million active users.
- Event Rate: Estimate 1 event per user per second, resulting in 10 million events per second (QPS).
- **Feed ...
Submit Your Answer
