Real questions from top companies · hard
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.
Design an ETL pipeline to process real-time stock market data.
Design an End-to-End ETL Pipeline.
Design an e-commerce platform like Flipkart
Design the architecture for an Online Ticket Booking System
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.