Interview Questions

Count the number of nulls in each column of a table.

Create Spark Session, read CSV, join, and write as table. Provide example code.

Create a SQL query to identify customers with purchases above a dynamic threshold.

Create data models for storing users, artists, and related data for music platform

Create partitioned table

Data Modeling and Airflow Scheduling - star schema, cron, backfill

Data Warehouse Design from scratch

Database vs Data Warehouse vs Data Mart vs Data Lake