JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.
Interview questions · medium
Describe a scenario where partitioning and bucketing would improve query performance.
When would you choose a Snowflake schema over a Star schema?
Implement a query to find the top 5 customers by total sales amount.
Write an SQL query to find duplicate emails in a users table.
Tell me about a time you handled a data pipeline failure during a critical operation.
Compute the moving average of daily transactions over a 7-day window.
Describe a time when you had to deal with a major data quality issue. How did you handle it?
Describe the concept of data sharding and when to use it.
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.