GSPANN Technologies interview question

2 rounds of technical interviews. Mostly questions on Pyspark, Sql, Airflow. Data sample will be given and you need to share screen and solve the queries. Optimization techniques, Memory management