Most popular Data Warehousing Interview Question- Azure Data Engineering Interview Question Tutorial

#ApacheSpark #DataEngineering #AzureDataEngineer #SparkSQL #DataTransformation #DataFrame #InterviewQuestion #BigData #AzureDatabricks #PySpark #DataAnalysis #DataScience #SQLQuery #Optimization #Efficiency #Tutorial

Welcome to our latest video where we delve into an essential interview question for Azure Data Engineers focusing on Type1 vs Type 2 in Data warehousing.

As Data Engineers, it's really important for us to understand SLD Type 1 and SLD Type 2 in DataWarehousing because they help us handle data that changes over time.

1️⃣ 𝐒𝐋𝐃 𝐓𝐲𝐩𝐞 1: When we use Type 1, it's like updating a piece of information and replacing the old version with the new one. For example, if someone moves to a new city, we simply update their address without keeping a record of their previous one.

2️⃣ 𝐒𝐋𝐃 𝐓𝐲𝐩𝐞 2: With Type 2, it's different. We keep track of changes over time by creating new entries. Using our previous example, if someone moves, instead of replacing their old address, we create a new entry with the updated address while retaining the old one. This way, we maintain a historical record of changes.

Understanding these methods helps us design data systems that accurately capture changes over time. By applying the right approach, whether it's SLD Type 1 or Type 2, we ensure our data remains reliable and supports informed decision-making processes.

– – – Book a Private One on One Meeting with me (1 Hour) – – –

– – – Express your encouragement by brewing up a cup of support for me – – –

– – – Other useful playlist: – – –

– – – Let’s Connect: – – –

Instagram: mrk_talkstech

– – – About me: – – –

Mr. K is a passionate teacher created this channel for only one goal "TO HELP PEOPLE LEARN ABOUT THE MODERN DATA PLATFORM SOLUTIONS USING CLOUD TECHNOLOGIES"

I will be creating playlist which covers the below topics (with DEMO)

1. Azure Beginner Tutorials
2. Azure Data Factory
3. Azure Synapse Analytics
4. Azure Databricks
5. Microsoft Power BI
6. Azure Data Lake Gen2
7. Azure DevOps
8. GitHub (and several other topics)

After creating some basic foundational videos, I will be creating some of the videos with the real time scenarios / use case specific to the three common Data Fields,

1. Data Engineer
2. Data Analyst
3. Data Scientist

Can't wait to help people with my videos.

– – – Support me: – – –

[neuera]

When u have unique ideas then how does. It take as a new record with same id?

[HemantKumar-suqt]

Hi sir

Kindly help me. I am an enthusiastic fresher data engineer. I want to create a data engineering project by taking a one month free subscription on Azure Cloud and show that project on my resume. If my one month free subscription on Azure Cloud expires and the resources get exhausted, will my data engineering project disappear or I will not be able to see it? Can I still show my data engineering project on my resume and the company can see it even after my one month free subscription on Azure Cloud expires?


Thank you so much

[Someonner]

Type 1 of what ??? U never mentioned SCD..