Microsoft Fabric Warehouse | DP-700 Exam Prep
Aleksi Partanen - Master Microsoft Fabric
9,285 views
🔥 Learn Microsoft Fabric hands-on!
👉 https://www.skool.com/fabricforge
🔥 Ace Your Certification Exams – Free Practice Questions!
👉 https://certiace.com/
☕ Enjoying the Content? Support the Channel!
💖 https://buymeacoffee.com/aleksipartan...
👨💼 Follow Me on LinkedIn!
🔗 LinkedIn: aleksi-partanen
🚨 Join the Free Microsoft Fabric Community on Discord!
👉 Discord: discord
📚 Recommended courses on Datacamp:
Python Data Fundamentals: https://datacamp.pxf.io/c/6429510/312...
Data Analyst in Python: https://datacamp.pxf.io/c/6429510/312...
SQL Fundamentals: https://datacamp.pxf.io/c/6429510/312...
Power BI Fundamentals: https://datacamp.pxf.io/c/6429510/291...
PL-300: Microsoft Power BI Data Analyst: https://datacamp.pxf.io/c/6429510/312...
Data analyst in Power BI: https://datacamp.pxf.io/c/6429510/312...
More courses: https://datacamp.pxf.io/c/6429510/207...
These are affiliate links. If you sign up through them, I may earn a small commission at no extra cost to you. Thanks for supporting the channel.
📂 Access Learning Materials (Files, Code, etc.)
💾 Download helpful resources here:
🔗 https://drive.google.com/drive/folder...
🎓 More of My Content:
🎥 DP-700 Microsoft Certified: Fabric Data En...
🎥 Microsoft Fabric Data Engineering
🎥 Microsoft Fabric Tutorials
🎥 DP-600 Microsoft Certified: Fabric Analyti...
🎥 Learn Azure Data Factory in 2026 - Full Co...
🎥 Learn Microsoft Fabric Data Pipelines in 2...
🎥 Learn Microsoft Fabric Notebooks in 2026 -...
🔗 All the Videos:
@aleksipartanentech
Are you preparing for the DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric exam? One of the most important data stores you need to understand is the Microsoft Fabric Warehouse — and this video has everything you need to know!
📌 What You’ll Learn in This Video:
🔷 What is the Microsoft Fabric Warehouse and how it works
🔷 How it compares to Lakehouse and other Fabric data stores
🔷 Ingesting data using pipelines, dataflows, notebooks, and COPY INTO
🔷 Accessing data using T-SQL, cross-database queries, and external tools
🔷 Key Warehouse features: Time Travel and Table Cloning
🔷 How Delta Parquet powers the Warehouse under the hood
✨ Why This Video Matters:
✅ Focused on exam-relevant content from the DP-700 curriculum
✅ Combines theory and real-world demos in Microsoft Fabric
✅ Great for both certification prep and hands-on data engineers
✅ Covers modern SQL capabilities that go beyond traditional databases
#MicrosoftFabric #Lakehouse #DP700 #DataEngineering #OneLake #DeltaLake #Parquet #SparkSQL #ShortcutCaching #DeltaTables #MicrosoftCertification #FabricExamPrep #AzureData #Certiace #PowerBI #NotebookIntegration
🏁 Timestamps:
00:00 Intro
01:12 Theory & Concepts
07:49 Demos & Tutorials
26:57 Practice Questions
16 Comments
If you want to review key topics, study offline, or follow along more easily, these PDFs are for you 🙌
Just check the "Additional study materials" perk after joining as a member to get access.
Thank you for supporting the channel and your own learning journey! 🎓
Practice with high quality, exam focused questions on CertiAce
https://certiace.com/
✔ Exam style questions
✔ Case studies
✔ Timed practice exams
🎯 YouTube channel members get a 50% discount code for CertiAce, plus additional exclusive benefits!
First of all, thank you for this content, I've been watching some episodes from this series, I like how they're structured and they are helping me to study for the exam!
Anyway there's one thing I didn't understand:
While inserting data on the Notebook using Spark SQL, you mentioned T-SQL is read-only. However, right after, you inserted the data on the warehouse table via SQL using INSERT, and after you also truncated too. If you could clarify, I got a bit confused, I understood that the methods to ingest data could be via pipelines, notebooks etc, but here you just inserted from another table using T-SQL.
I’m a bit surprised that you haven’t mentioned the absence of the IDENTITY column feature in Warehouse tables. I discovered that the CREATE TABLE statement doesn’t support defining a column with IDENTITY, nor does it support CREATE SEQUENCE. When I searched the community forum, one suggestion was to use a HASHKEY() function on a column. However, since it depends on the column’s value, it could cause issues if that value changes. What are your options?
Now I'm curious what he's going to do in video #15.
So it uses Zero Copy method, but data is still available in the cloned table after deleting the first one, as you showed in the video. My question is, how come it can still show the previous data, if it's not a full physical copy.
Does this mean it's using the historical data from the delta format? So I wonder what happens if we delete all history of the table after cloning. Will data still be available in the cloned table? And if it is, why is that, if it's not a full physical copy?
Microsoft Fabric Warehouse | DP-700 Exam Prep
Aleksi Partanen - Master Microsoft Fabric
9,285 views
🔥 Learn Microsoft Fabric hands-on!
👉 https://www.skool.com/fabricforge
🔥 Ace Your Certification Exams – Free Practice Questions!
👉 https://certiace.com/
☕ Enjoying the Content? Support the Channel!
💖 https://buymeacoffee.com/aleksipartan...
👨💼 Follow Me on LinkedIn!
🔗 LinkedIn: aleksi-partanen
🚨 Join the Free Microsoft Fabric Community on Discord!
👉 Discord: discord
📚 Recommended courses on Datacamp:
Python Data Fundamentals: https://datacamp.pxf.io/c/6429510/312...
Data Analyst in Python: https://datacamp.pxf.io/c/6429510/312...
SQL Fundamentals: https://datacamp.pxf.io/c/6429510/312...
Power BI Fundamentals: https://datacamp.pxf.io/c/6429510/291...
PL-300: Microsoft Power BI Data Analyst: https://datacamp.pxf.io/c/6429510/312...
Data analyst in Power BI: https://datacamp.pxf.io/c/6429510/312...
More courses: https://datacamp.pxf.io/c/6429510/207...
These are affiliate links. If you sign up through them, I may earn a small commission at no extra cost to you. Thanks for supporting the channel.
📂 Access Learning Materials (Files, Code, etc.)
💾 Download helpful resources here:
🔗 https://drive.google.com/drive/folder...
🎓 More of My Content:
🎥 DP-700 Microsoft Certified: Fabric Data En...
🎥 Microsoft Fabric Data Engineering
🎥 Microsoft Fabric Tutorials
🎥 DP-600 Microsoft Certified: Fabric Analyti...
🎥 Learn Azure Data Factory in 2026 - Full Co...
🎥 Learn Microsoft Fabric Data Pipelines in 2...
🎥 Learn Microsoft Fabric Notebooks in 2026 -...
🔗 All the Videos:
@aleksipartanentech
Are you preparing for the DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric exam? One of the most important data stores you need to understand is the Microsoft Fabric Warehouse — and this video has everything you need to know!
📌 What You’ll Learn in This Video:
🔷 What is the Microsoft Fabric Warehouse and how it works
🔷 How it compares to Lakehouse and other Fabric data stores
🔷 Ingesting data using pipelines, dataflows, notebooks, and COPY INTO
🔷 Accessing data using T-SQL, cross-database queries, and external tools
🔷 Key Warehouse features: Time Travel and Table Cloning
🔷 How Delta Parquet powers the Warehouse under the hood
✨ Why This Video Matters:
✅ Focused on exam-relevant content from the DP-700 curriculum
✅ Combines theory and real-world demos in Microsoft Fabric
✅ Great for both certification prep and hands-on data engineers
✅ Covers modern SQL capabilities that go beyond traditional databases
#MicrosoftFabric #Lakehouse #DP700 #DataEngineering #OneLake #DeltaLake #Parquet #SparkSQL #ShortcutCaching #DeltaTables #MicrosoftCertification #FabricExamPrep #AzureData #Certiace #PowerBI #NotebookIntegration
🏁 Timestamps:
00:00 Intro
01:12 Theory & Concepts
07:49 Demos & Tutorials
26:57 Practice Questions
👉 https://www.skool.com/fabricforge