Real questions from top companies
Aggregate surface areas and calculate cumulative surface area using the LAG function.
Are you comfortable with the variable pay structure, and what are your expectations for the base salary?
CSV Without Column Names/Schema - how to read
Calculate the cumulative transaction amount for each month using a transaction table.
Can CASE statements be used in an UPDATE query?
Can you chain multiple triggers for a single pipeline?
Cloud Architecture - explain
Compare Airflow's @daily vs once trigger scheduling.
Compare OLTP and OLAP systems in the context of financial transactions.
Compare PostgreSQL vs Snowflake. How do they handle duplicate record errors?
Compare Redshift, BigQuery, and Snowflake in terms of cost, performance, and scalability.
Compare the star schema and snowflake schema. Which one would you use for reporting at Swiggy, and why?
Connecting BigQuery with Linux
Consolidate hotel reviews and create a dashboard. Design a data model for the reviews.
Converting SCD0 to SCD3
Create Spark Session, read CSV, join, and write as table. Provide example code.
Data Warehouse Design from scratch
Describe a challenging project where you optimized a complex ETL process.
Describe a situation where you had to redesign a data model to meet changing business needs
Design a Custom API that can query a backend server and return customer data such as the number of orders placed by a user based on their user ID
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.