Data Engineering Mock Interview | Spark Optimization Interview Questions | Best Coding Practices

[@Journey_with_Subham]

Sachin is really knowledgeable, and he is helping to answer the questions as well with Suman.

[@sumitmittal07]

yes both have been great. Kudos to Sachin & Suman.

[@harshavardhanachyuta2055]

I like the way Sachin asked the question by asking what are the best practises you follow in sql, pyspark to understand better

[@AliKhanLuckky]

36:03 1.he is asking only highest 2. Dept vise highest Use sql code as follow 1.select max(salary) from emp; 2 select dept,max(salary) from emp group by dept; As simple as that he did not asked you to write window function if he ask you then do it 😊

[@sriharidhanakshirur9245]

In case 1 , we should use WinDow function bcoz, we need to print id and name as well

[@AliKhanLuckky]

@@sriharidhanakshirur9245 in this case u can use sub query as well if anyone explicitly ask you is there any other way or do it using windows then at that time interviewer will get impress 😊

[@isenhiem]

This is such an amazing initiative...While watching the video I felt like as if I was being interviewed...I cant stress on how helpful this will be for so many people. It gave me a very good idea of the level of my preparation. Thanks a lot and I hope you will create more videos like this.

[@crunchyworks6374]

Sir as I see from last 3 days everytime cloud tech you use is Azure only , please make it on AWS too it’s very helpful

[@sumitmittal07]

definitely, you will see a lot of variety

[@sangamrathore-b9z]

Thank you so much Sumit sir.Really a great initiative

[@sumitmittal07]

thank you very much

[@prannay19]

Great initiative. Thank you Sumit Sir 🙏. Looking forward to more such videos. Keep up the good work 👍

[@sumitmittal07]

Thanks a ton

[@RishabhKalia-w6p]

if possible mention the experience also , to which experience level these interview are targeting (like this is for 1 year, fresher or for 3 year experience )

[@RohitSharma-ny1oq]

Plz increase little bit complexity of interview because in actual its more complex 😊

[@sumitmittal07]

candidates mostly get stuck in basic fundamentals. These are actual people who conduct interviews in companies.

[@DataJourneyHuub]

Thank you Sumit Sir

[@sumitmittal07]

you are welcome

[@IsmailKhan-jy9ew]

Thankyou sumit sir for this initiative.

[@sharankarthick3364]

Informative!