Real questions from top companies in SQL
Snowflake: Types of Caching, Time Travel vs. Fail-safe, Snowpipe, Materialized Views
Solve a coding question related to window functions using SQL and PySpark.
Solve a problem using a window function in Spark or SQL.
Solve a query using window functions and GROUP BY to rank or aggregate data.
Solve a running sum query
Solve medium-level SQL questions involving two tables with null values - LEFT JOIN, RIGHT JOIN, INNER JOIN
Spark optimizations: Partitioning, caching, tuning parallelism
Stored Procedure Optimization
Stored Procedures in SQL
Strategies for working with busy team leads?
Tasks where the candidate faced failure and lessons learned.
Tell us about a project where you optimized an existing process or pipeline. What was the impact?
Teradata to Hadoop migration and handling data with SCD Type 2?
Test SQL skills using advanced window functions such as LAG, LEAD, and DENSE_RANK.
Time and cost comparisons for executing the same query in Snowflake and Spark.
Two tables: Table 1 has 8 records, Table 2 has 2 records, common column id. How many records would result with Inner Join, Left Join, Right Join, Full Outer Join?
Use cases for internal staging in Snowflake?
Using Airflow to trigger and manage ETL jobs?
What are Assert Transformations, and where are they used?
What are BigQuery Slots?
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.