Count the number of nulls in each column of a table.
SQLeasy
2
Create a SQL query to identify customers with purchases above a dynamic threshold.
SQLeasy
3
Data Modeling and Airflow Scheduling - star schema, cron, backfill
SQLeasy
4
Database vs Data Warehouse vs Data Mart vs Data Lake
SQLeasy
5
Define cursors and stored procedures and their use cases.
SQLeasy
6
Describe a scenario where you had to collaborate with a cross-functional team to deliver a solution.
SQLeasy
7
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?
SQLeasy
8
Describe a situation where you made a mistake in a data pipeline. How did you identify and fix it?
SQLeasy
+20 More Questions with Expert Answers
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.