Design real-time exchange data sync system evaluates requirements, scale assumptions, API/data design, architecture, trade-offs, failure modes, and rollout in a realistic interview setting. A strong answer states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.
Design a system that continuously ingests and syncs stock data from multiple exchanges and renders an always up-to-date web page. Cover data sources (polling vs. streaming), schema normalization, deduplication, handling time zones and out-of-order events, caching and storage, API design, client updates (WebSocket/SSE), consistency and latency targets, fault tolerance and backfill, rate limiting, scaling and partitioning, observability, security, and cost considerations.
Quick Answer: Design real-time exchange data sync system evaluates requirements, scale assumptions, API/data design, architecture, trade-offs, failure modes, and rollout in a realistic interview setting. A strong answer states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.
System Design: Real-Time Multi-Exchange Stock Data Ingestion and Live Web Page
Context
You are asked to design a production system that continuously ingests stock market data from multiple exchanges and renders an always up-to-date web page for users. Data includes trades and quotes (top-of-book), and the system must support historical queries and real-time streaming updates.