DP-600 · Question #116
You are managing a set of Dataflow Gen2 queries that are currently ingesting tables into a Fabric lakehouse. You need to ensure that the tables are optimized for Direct Lake connections that will be…
The correct answer is C. Use OPTIMIZE to apply V-Order. To optimize lakehouse tables ingested by Dataflow Gen2 for Direct Lake connections used by semantic models, you should use the OPTIMIZE command to apply V-Order.
Question
You are managing a set of Dataflow Gen2 queries that are currently ingesting tables into a Fabric lakehouse. You need to ensure that the tables are optimized for Direct Lake connections that will be used by connected semantic models. What should you do?
Options
- AApply an incremental refresh policy to the semantic model refreshes.
- BRun the VACUUM command.
- CUse OPTIMIZE to apply V-Order.
- DUse shortcuts to the lakehouse tables from the semantic models.
How the community answered
(36 responses)- A11% (4)
- B14% (5)
- C69% (25)
- D6% (2)
Why each option
To optimize lakehouse tables ingested by Dataflow Gen2 for Direct Lake connections used by semantic models, you should use the OPTIMIZE command to apply V-Order.
Applying an incremental refresh policy to the semantic model refreshes optimizes the *refresh process* for the semantic model itself, not the underlying lakehouse tables for Direct Lake query performance.
The VACUUM command is used to remove old, unreferenced data files from a Delta table's history, reducing storage size, but it does not directly optimize for Direct Lake read performance like V-Order does.
Direct Lake mode in Fabric semantic models achieves high performance by directly reading data from Delta tables in the Lakehouse. Applying V-Order through the OPTIMIZE command significantly enhances Direct Lake query performance by organizing the Delta table data files in a specific way that aligns with the needs of analytical workloads, improving scan efficiency and reducing I/O.
Using shortcuts allows semantic models to reference lakehouse tables, but it's a method of connection, not an optimization technique for the physical data storage that enhances Direct Lake performance.
Concept tested: Direct Lake optimization (V-Order)
Source: https://learn.microsoft.com/en-us/fabric/data-engineering/delta-lake-optimize-vorder
Topics
Community Discussion
No community discussion yet for this question.