Capgemini interview question

Optimization techniques in Spark SQL queries using joins