Real questions from top companies
Optimization techniques - partitioning, caching, broadcast joins, bucketing
Optimization: Performance tuning strategies and temporal tables
Optimize SQL using indexing and partitioning filters.
Optimize a query fetching customer data with a rolling 6-month sales sum.
Optimize a slow SQL query for a large orders table containing billions of rows.
Optimizing Spark Jobs when they take longer than expected
PIVOT Operator in T-SQL
Partitioning a table with card details and transactions?
Predict the output of SQL joins (INNER, LEFT, RIGHT) on dataset containing 0, NULL, and 1
Predicted outputs for different join types using two sample tables with NULL values.
Print only the newest record for each name – Use SQL Window functions (ROW_NUMBER, RANK, etc.)
Query Optimization Strategies
Query Performance in Redshift - optimization
Query for 2nd Latest Joining Per Department
Query to Print Match List Against Every Team
REPARTITION vs COALESCE for managing partitions
Rank, Dense Rank, and Row Number - Differences
Real-Time Scenarios with Stored Procedures
Remove duplicates, fill missing values, and apply schema validation using ScalaSpark
Removing duplicates - ROW_NUMBER() or DISTINCT
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.