Live Azure Data Engineering Mock Interview | Technical Round | Out of Memory Issue | SQL
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.
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, Solon Kumar Das, / solondas shares invaluable insights and practical guidance drawn from his extensive expertise in the Big Data Domain.
Our expert guest interviewee, shashank chakrawarty, / cshashank 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
Пікірлер: 7
Delta table maintains history with the help of transaction lo files which are in json format. This log files helps delta table to maintain different table snapshot version, time travel feature and maintain ACID property. As we know concurrent read and write opearions is possible in delta tabel by the log files. The actual data is stored in delta table stored in parquet format. Over the time it geneerates so much small data files and to comapct the smaller files we can use optimize and zorder command on delta table. The VACUUM command in Delta Lake is used to remove old data files that are no longer accessible from the current state of the table and are beyond the retention period and not part of the latest snapshot version of delta table.
@solondas96
2 ай бұрын
Great explanation ❤
@imranhossain1660
2 ай бұрын
@@solondas96 Thank you
Data Engineer interview series helping a lot. Please make videos on GCP as well. Thanks.
This Mock interviews series is really good, but how do we know that candidates attending interview is anwering correctly or not. If he or she answers wrong then how do we know?
@abhishekmohanty9971
2 ай бұрын
Just my suggestion, dont look for correct answers in interview. If you know the answer already then you know whether its wrong or correct. If you dont know then i would suggest please read on that topic because you will not get complete picture even if the interviewee is correct. Just look how the interviwee is approaching the questions even to the unknown questions plus what kind of questions are being asked. I hope your query is aptly answered.
@solondas96
2 ай бұрын
Aptly explained abhishek. Mock interviews are mostly to test a candidate’s approach to a certain problem. In an interview there is no complete right or wrong answer. It basically tests on the candidates ability to hold their composure and try their best to reach the solution to the question asked. Let me know if you want to know all the correct answer to the questions i have asked. I would post it in the comments section for your reference. 😊 Happy Learning