Real questions from top companies in SQL · hard
What strategies and technologies would you consider when designing a data warehouse architecture for efficient data storage and retrieval?
What technologies are you most comfortable with?
What's the role of surrogate keys in dimensional modeling?
Write a query to generate the specified output using advanced SQL skills with joins, aggregations, and window functions.
You need to create a workflow where Task B runs only if Task A is successful, and Task C should always run regardless of Task A or B's status. How would you define this dependency using Airflow?
You need to design a Kafka topic for a logging service. How would you decide the number of partitions and the key for partitioning to balance throughput and ordering requirements?
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.