Must Watch Live Mock Interview For Data Engineers | System Design | Data Modeling

To enhance your career as a Cloud Data Engineer, Check trendytech.in/?src=youtube&su... for curated courses developed by me.
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
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
Our highly experienced guest interviewer, Apoorv Gupta, / apoorvgpt9 shares invaluable insights and practical guidance drawn from his extensive expertise in the Big Data Domain.
Our expert guest interviewee, Trisha Ghoshal, / trisha-ghoshal-304633168 has an interesting approach to answering the interview questions on Apache Spark, SQL and Azure Cloud Services.
Link of Free SQL & Python series developed by me are given below -
SQL Playlist - • SQL tutorial for every...
Python Playlist - • Complete Python By Sum...
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 :
LinkedIn - / bigdatabysumit
Twitter - / bigdatasumit
Instagram - / bigdatabysumit
Student Testimonials - trendytech.in/#testimonials
TIMESTAMPS : Questions Discussed
00:00 Introduction & Project Responsibilities
10:17 Joins in SQL and Use Cases
21:40 Scenario-Based System Design Question
43:03 Data Storage: Data Warehouse vs. Deltalake
49:50 Scenario-Based Data Modeling Question
Music track: Retro by Chill Pulse
Source: freetouse.com/music
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

[@mohithakrishna3125]

This was really helpful and would be very useful to start preparing for data engineer interviews. Thank you Apoorv for giving us an interviewer pov. Looking forward to more such content!

[@AnuragVardhan-lt3rc]

Great eye opener and great knowledge shared

[@shreyaspurankar9736]

Valuable insights. Helpful for me.

[@vanshikagupta2782]

Very insightful 😃

[@gaganpratap7016]

Valuable insights appuu sir❤❤

[@ranjitdhiwar8545]

Nice insights Apoorv.!

[@VenkatBala-jv2yh]

Great questions....

[@sonuparmar5836]

Incase someone have doubts regarding joins she answered, her answers are right. All will have 6 records as output.

[@apoorvgupta1993]

Yes, she is absolutely right😁

[@dhanushkumarpalani424]

when i tried i got around 9 records for cross join kindly confirm it

[@yudhveersingh8177]

Please suggest a chennal for pyspark

[@apoorvgupta1993]

What exactly are you looking to learn?

[@RohitSharma-ny1oq]

inner join ==3 records

[@apoorvgupta1993]

Ideally it should be 6 records as you will get a matching record every single time😬

[@RohitSharma-ny1oq]

@@apoorvgupta1993 thanks Sir , so duplicate combinations also included

[@apoorvgupta1993]

Yes, in sql we can definitely get duplicate records.. that’s why we have the DISTINCT keyword to get only the distinct records if we want