JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.
Real questions from top companies · medium
How would you handle data type changes for an existing column?
How would you handle duplicate or corrupted data in a batch ETL job?
How would you handle nulls in a SQL join? Provide examples using COALESCE.
How would you identify duplicate records based on a composite key in SQL?
How would you optimize a query fetching sales data across multiple countries with billions of rows?
How would you optimize a query with multiple joins and subqueries?
How would you prevent small file problems in S3 when loading data into Redshift?
How would you retrieve the first and last order for each customer from a sales table?
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.