DP-700 - Monitor and Optimize an Analytics Solution - Section 3.6
Optimize a Lakehouse table, including V-Order, file compaction, and partitioning.
Optimise a Lakehouse Delta table using V-Order write optimisation, OPTIMIZE bin-compaction to merge small files, and Z-order to enable data skipping. Apply partitioning strategies to avoid the small-file problem, and use VACUUM to enforce Delta retention and reclaim storage.
V-Order write optimisationOPTIMIZE and bin-compactionVACUUM and Delta retentionpartitioning and the small-file problemZ-order and data skipping
More in this domain
Back to all Monitor and Optimize an Analytics Solution objectives, or the DP-700 cert hub.
Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.