Monitoring & optimizing performance in Microsoft Fabric | DP-600 EXAM PREP (8 of 12)

Free DP-600 study notes inside community: www.skool.com/microsoft-fabri...
In this video (8 of 12 in the series), we cover the following sections of the DP-600 study guide:
- Identify and resolve data loading performance bottlenecks in dataflows, notebooks, and SQL queries
- Implement performance improvements in dataflows, notebooks, and SQL queries
- Identify and resolve issues with Delta table file sizes
- Implement file partitioning for analytics workloads in a lakehouse
Specifically, we take a look at concepts like: dataflow performance monitoring, dataflow staging, dataflow fast copy, SQL DMVs, SQL Query Insights, Spark monitoring, Spark History Server, the Capacity Metrics App, the Monitoring Hub, Delta file optimization, File Partitioning, VACUUM & OPTIMIZE.
This video is part of the DP-600 Exam Preparation series: • DP-600 Exam Preparation
Timeline
0:00 Intro
1:14 Framing performance optimization in Fabric
4:00 Monitoring Hub
6:13 Capacity Metrics App
9:18 Dataflow monitoring
9:55 Dataflow staging
12:06 Dataflow fast copy
12:41 SQL Dynamic Management Views (DMVs)
15:00 SQL Query Insights
16:28 Spark monitoring
17:15 Spark History Server
18:06 Delta table optimization (intro)
18:38 File partitioning
25:30 V-order optimization
27:00 Delta OPTIMIZE & VACUUM
27:36 Spark coalesce() and repartition()
29:20 Practice Questions
34:15 Outro and next steps
#microsoftfabric #dp600 #powerbi

[@LearnMicrosoftFabric]

How did you do in the practice questions? Starting to feel more confident about Fabric & DP-600?? Let me know below 👇

[@oumouratouannasow6190]

I had a 3/5 😅. But yes, I learn a lot from each video.

[@LearnMicrosoftFabric]

@@oumouratouannasow6190 It's great to hear you're learning a lot from each video!!

[@nagarjunabm2738]

I got a 3/5! But these practice questions at the end help a lot! Especially because you explain why the other options are wrong. Great video!

[@user-ug1lq7qj9g]

I could not access skool community notes ,it's saying locked at level 1.Please help will

[@Azureandfabricmastery]

Informative topic, Thanks

[@ramakumarguntamadugu1299]

🎉thanks , great explanation!

[@VeeraForBharat]

Thanks @LearnMicrosoftFabric! . Looking forward to a detailed video on performance especially with VOrder and how to make the multi table join queries more efficient

[@LearnMicrosoftFabric]

Yeh for sure, would like to cover these important topics in more detail!

[@777bashir]

Thanks a bunch for this awesome channel ! Quick question, though: Are you a real human, or just a super smart AI? Keep up the great work!

[@LearnMicrosoftFabric]

😂 thanks, glad you're enjoying 🙌

[@carlosnavia1361]

✅

[@user-bg4wu1gs6i]

hi, i tired to schedule for exam through office id failed when i tried through personal id i didnt see any discounts even though i got my mail on office email

[@LearnMicrosoftFabric]

Yeh you'll need to use the same account you used to get the voucher to book the exam, I believe

[@user-bg4wu1gs6i]

@@LearnMicrosoftFabric I tired with office email but its showing issues