Real questions from top companies
Design a data pipeline for streaming analytics.
Design a data pipeline from end to end - describe how data would be ingested, processed, stored, and queried.
Design a data pipeline to collect, process, and visualize customer feedback from Adidas stores worldwide.
Design a data pipeline to ingest and process clickstream data in near real-time
Design a data pipeline to ingest and process data from multiple sources (e.g., S3, Kinesis) to Redshift using Spark.
Design a data warehouse for 7-11 or 24x7 stores
Design a data warehouse for a grocery store.
Design a data warehouse schema to track orders, customers, delivery partners, and payments.
Design a database schema for tracking stock trades in real-time.
Design a database schema to store customer transactions, including attributes like region, product category, and timestamp.
Design a high-level system for a Netflix-like app.
Design a logging and monitoring solution for a mission-critical data pipeline.
Design a pipeline capable of processing 1TB of data per day.
Design a project architecture visually and explain key components.
Design a real-time data pipeline for clickstream events. How to ensure fault tolerance? Where to implement deduplication logic? How to efficiently store 1 billion+ rows?
Design a real-time message stream processing system
Design a scalable system for processing real-time sales data from multiple stores, storing it for analytics, and generating reports.
Design a schema for a retail store's sales data, explaining your choice of dimensions and facts
Design a system to handle 1M daily transactions with real-time analytics for Swiggy.
Design a working data pipeline to efficiently store, process, and report data.
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.