nerdexam
Microsoft

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.

Submitted by mateo_ar· Apr 18, 2026Prepare and serve data

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)
  • A
    11% (4)
  • B
    14% (5)
  • C
    69% (25)
  • D
    6% (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.

AApply an incremental refresh policy to the semantic model refreshes.

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.

BRun the VACUUM command.

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.

CUse OPTIMIZE to apply V-Order.Correct

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.

DUse shortcuts to the lakehouse tables from the semantic models.

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

#Fabric Lakehouse#Direct Lake Optimization#V-Order#Delta Lake

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice