Question 19
The given programs are an example of ETL and will be bottlenecked on thestring split happening on the Python VM.
The given programs are together an example of ELT that maximally utilizesthe Spark cluster and no further performance optimizations are required.
By moving the string split into PySpark driver program, I can get rid of thePython program and thus make the program an ELT.
Rewriting the string split to use native PySpark dataframe string functions willbe best suited for performance.