Big Data Interview | Mock | Problem Solving | Technical Round | Pyspark , SQL #interview #question

I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦!

"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."

𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -

BIG DATA INTERVIEW SERIES

This mock interview series is launched as a community initiative under Data Engineers Club aimed at aiding the community's growth and development

Link of Free SQL & Python series developed by me are given below -

Don't miss out - Subscribe to the channel for more such informative interviews and unlock the secrets to success in this thriving field!

Social Media Links :

TIMESTAMPS : Questions Discussed

Music track: Retro by Chill Pulse
Background Music for Video (Free)

Tags
#mockinterview #bigdata #career #dataengineering #data #datascience #dataanalysis #productbasedcompanies #interviewquestions #apachespark #google #interview #faang #companies #amazon #walmart #flipkart #microsoft #azure #databricks #jobs

[mayanksatija]

As per me, we can do the second question with below :

with t1 as (
select customer_number, count(*) as count from orders group by customer_number)

select t1.customer_number from t1 where t1.count = (select max(count) from t1)

[SunilKumar-hqbt]

I think the join condition in the solution for the first question should be employee(e1).managerid = employee(e2).id.

[anithas]

1.1st qstn, the join condition should be like
ON e.manager_id = m.id
WHERE e.sal > m.sal

So you can match the manager id first nd check for the manager's id coming as emp id which will give the proper answer i gss

2. Also 2nd qstn we can do
order by count(ord_no) desc limit 1
Which will fetch the cust no who placed largest no.of orders in general

Correct me if I'm wrong

[gurupradeep]

first one

Select name from salary_table as a where salary>(select salary from salary_table where id =a.managerid)

[souravdas-ktgg]

with c as(select e.*, m.salary as manager_salary, m.name as manager_name
from employees_prac e left join employees_prac m
on e.managerid=m.id where e.salary-m.salary>0)

select name from c;
My solution

[gudiatoka]

In real life coalesce is used while writing/saving the data in storage location in single partion while repartition is used to achieve parallelism that will use worker node properly

[gudiatoka]

Dear team..missing your videos of mock interview..pls do upload ❤

[gudiatoka]

GroupByKey and reduceByKey both used on rdd level

[dataanalyst]

not cool second sql question answer is wrong and if interview went wrong at least you can put the correct answe at the end of video this will help full for others it is not like just posting the thing.

[sabmelegarebaba]

Hi Brother currently I am doing job in TCS and i am BCA graduate and I am thinking that after I will complete 2 year in tcs I will take Leave without pay for 2 year and I will do Full time MCA. Its that right way I am going or wrong way . Please suggest me what to do or esle I will go with Part time MCA ??

[abhishekmodak]

This is not upto the mark interview. Answers are wrong for sql query.

[kamalprajapati]

Select customer_id from(Select top 1 Customer_id, count(order_id) as NO_of_orders from orders group by customer_id order by No_of_orders desc);

[ynreddy]

The query which wrote in the video for salary is wrong. here is the exact query which will work
select e.sal, e.name, e.emp_id, e.mngr_id from employee e
inner join employee m on e.emp_id=m.mngr_id
where(e.sal<m.sal)