Published On May 10, 2024
Free DP-600 study notes inside community: https://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