Apache Spark 1st Technical Round Live Interview for Experienced Candidates | Azure | SQL

Sdílet
VloÅŸit
  • čas přidán 9. 04. 2024
  • 𝐓𝐚 𝐞𝐧𝐡𝐚𝐧𝐜𝐞 𝐲𝐚𝐮𝐫 𝐜𝐚𝐫𝐞𝐞𝐫 𝐚𝐬 𝐚 𝐂𝐥𝐚𝐮𝐝 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫, 𝐂𝐡𝐞𝐜𝐀 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.
    𝐖𝐚𝐧𝐭 𝐭𝐚 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐚𝐮𝐠𝐡 𝐭𝐡𝐞 𝐊𝐚𝐬𝐭 𝐬𝐚𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐚𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐊𝐩𝐢𝐚𝐧𝐬 𝐏𝐫𝐚𝐠𝐫𝐚𝐊!
    "𝐀 8 𝐰𝐞𝐞𝐀 𝐏𝐫𝐚𝐠𝐫𝐚𝐊 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐚 𝐡𝐞𝐥𝐩 𝐲𝐚𝐮 𝐜𝐫𝐚𝐜𝐀 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐚𝐟 𝐭𝐚𝐩 𝐩𝐫𝐚𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐚𝐊𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐚𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐚𝐮𝐠𝐡𝐭 𝐩𝐫𝐚𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐚𝐚𝐜𝐡 𝐭𝐚 𝐬𝐚𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐚𝐛𝐥𝐞𝐊."
    𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐚𝐰 𝐲𝐚𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐚𝐫 𝐭𝐡𝐞 𝐏𝐫𝐚𝐠𝐫𝐚𝐊 -
    𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐚𝐧 𝐋𝐢𝐧𝐀 (𝐂𝐚𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐚𝐊 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
    𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐚𝐧 𝐋𝐢𝐧𝐀 (𝐂𝐚𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐚𝐊 𝐚𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
    30 INTERVIEWS IN 30 DAYS- 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, Ankur Bhattacharya, / ankur-bhattacharya-100... shares invaluable insights and practical guidance drawn from his extensive expertise in the Big Data Domain.
    Our expert guest interviewee, Dhruv Dubey, / dhruvadubey has an interesting approach to answering the interview questions on Spark, SQL, Azure Services & Big Data Project.
    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:58 Introduction and project explanation
    2:51 Reason for migrating from GCP to AWS?
    3:57 Use cases solved in migration projects, challenges faced, and volume of data?
    9:44 Explanation of cost savings and performance improvements mentioned in the resume?
    10:40 Explain the reason for the out of memory issue that you faced.
    12:00 How can you optimize data access performance for teams using ingested data during the day, given nightly ingestion in RDBMS?
    20:56 How is the history stored in delta tables?
    22:50 Features offered by delta tables?
    23:35 Explain meaning and types of ACID properties.
    25:35 Explanation of normalization and denormalization, types of normalization?
    28:05 Preferred table type for aggregated reporting: wide or long?
    29:21 Sql coding questions
    37:10 Python coding questions
    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

Komentáře • 8

  • @shilpychakraborty-ih6xc
    @shilpychakraborty-ih6xc Před 3 měsíci

    Thank you for sharing this❀

  • @shahnawazatharkazmi2826
    @shahnawazatharkazmi2826 Před 3 měsíci

    Do you have providing live training or only record video training

  • @divyaborse5866
    @divyaborse5866 Před 3 měsíci

    How to calculate stages and task for 2 wide transformation and 1 action for 2gb of data
    I got that no of jobs =no of actions plz help me

    • @MrinalDas3107
      @MrinalDas3107 Před 22 dny

      1 action = 1 job, every wide trans is = 1 stage and +1 default stage so for n wide trans there will be n+1 stages

  • @srinivasgrathod2497
    @srinivasgrathod2497 Před 3 měsíci

    Is it (64 core 16gb) or (16core 64gb)?
    Thank you for the series.

  • @skybluelearner4198
    @skybluelearner4198 Před 2 měsíci

    The answers are not upto the mark.