Real questions from top companies
What is a semi-join?
What is dynamic partition pruning, and how does it optimize query execution?
What is the difference between UNION and UNION ALL? Which one is faster and why?
What is the difference between static and dynamic partitioning in Hive?
What optimizations would you apply for partitioning strategies?
What strategies and technologies would you consider when designing a data warehouse architecture for efficient data storage and retrieval?
What strategies would you use to manage dynamic partitions efficiently?
When would you choose partitioning over bucketing, or vice versa?
Write SQL query to replace specific patterns in a string column.
Write a SQL query to find departments with more than 10 employees.
Write a SQL query to find house with Avg(score) > 70.
Write a SQL query to find the top 5 products by sales per region.
Write a query to calculate Monthly Active Users (MAUs) for July 2022
Write a query to find minimum age.
Write a query to find the median salary of employees in a table.
Write a query to find the total number of rides per driver in the last 30 days.
Write a self join query to get the manager's name for each employee.
Write code to find the third-highest salary in a dataset using Pandas.
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?
Alternatives to the Medallion Architecture
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.