Tredence Interview Question

Spark optimizations,Sql order of execution?