In a Direct Lake semantic model that uses Delta tables and warehouse row-level security, when users interact with a report, which mode will the DAX queries use?

In a Direct Lake semantic model that uses Delta tables and warehouse row-level security, when users interact with a report, which mode will the DAX queries use?

• A. DirectQuery
• B. Import
• C. Composite
• D. Dual

Answer: (A)

Direct Lake relies on querying the data where it lives, so every interaction with the report sends DAX queries directly to the Delta tables in the data lake. This is DirectQuery behavior: the data isn’t loaded into the model, it’s evaluated against the lake each time, which also allows the warehouse’s row-level security to be enforced at query time. Using a mode that caches data or mixes storage would break the direct lake pattern and could lead to stale results or security gaps, so the direct query path is the correct fit for this setup.

Direct Lake relies on querying the data where it lives, so every interaction with the report sends DAX queries directly to the Delta tables in the data lake. This is DirectQuery behavior: the data isn’t loaded into the model, it’s evaluated against the lake each time, which also allows the warehouse’s row-level security to be enforced at query time. Using a mode that caches data or mixes storage would break the direct lake pattern and could lead to stale results or security gaps, so the direct query path is the correct fit for this setup.