Real questions from top companies
Schema Changes in Source (New Column Addition) - Impact
Schema Design: Star vs. Snowflake schema differences
Self-introduction including current role, projects, and key responsibilities. Focus on SQL expertise, Python skills, and experience in data warehousing and modeling.
Self-joins to compare employee salaries?
Serverless vs. Dedicated SQL pools
Share a situation where you took ownership of a failing project.
Share an example where you had to communicate technical concepts to a non-technical audience.
Share strategies for query and ETL optimization.
Simulate a producer-consumer model using multithreading.
Slowly Changing Dimension (SCD) Type 4 - describe hybrid approach
Snowflake Tech Stack: Deployment on Azure, cluster sizing considerations, and overall data warehouse design?
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
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.