Real questions from top companies in SQL · easy
Count the number of nulls in each column of a table.
Create a SQL query to identify customers with purchases above a dynamic threshold.
Data Modeling and Airflow Scheduling - star schema, cron, backfill
Database vs Data Warehouse vs Data Mart vs Data Lake
Define cursors and stored procedures and their use cases.
Describe a scenario where you had to collaborate with a cross-functional team to deliver a solution.
Describe a scenario where you had to make trade-offs between data processing speed and accuracy. How did you approach this situation and what was the outcome?
Describe a situation where you made a mistake in a data pipeline. How did you identify and fix it?
Describe a situation where you prioritized business needs over technical elegance. How did you manage trade-offs?
Describe how you would implement Slowly Changing Dimensions (SCD) in an ETL workflow.
Describe the process for migrating data from an on-premises SQL database to AWS. What services and strategies would you use?
Did you review the job description? Why are you interested in this role?
Discuss a situation where you had to balance technical priorities and business goals.
Discuss how you handled null values or unstructured data in your previous projects.
Does a Common Table Expression store data? If not, how does it function in SQL?
Error Handling in T-SQL - TRY...CATCH, THROW, RAISEERROR
Explain Coalesce vs ISNULL. What are the differences in SQL?
Explain ETL process flags and segregation of steps.
Explain Kafka messaging guarantees and Snowflake schema evolution.
Explain Slowly Changing Dimensions (SCD) and its types
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.