DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ102

Implement and manage semantic models

You have a custom Direct Lake semantic model named Model1 that has one billion rows of data.

You use Tabular Editor to connect to Model1 by using the XMLA endpoint.

You need to ensure that when users interact with reports based on Model1, their queries always use Direct Lake mode.

What should you do?

  • A From Model, configure the Default Mode option.
  • B From Partitions, configure the Mode option.
  • C From Model, configure the Storage Location option.
  • D From Model, configure the Direct Lake Behavior option.
Explanation

The DirectLakeBehavior property (configured to 'DirectLakeOnly') ensures all queries use Direct Lake mode without fallback to DirectQuery. This is critical for a one-billion-row semantic model to maintain optimal performance. The property is configured via Tabular Editor using TOM or TMSL, not through Default Mode, Partitions Mode, or Storage Location settings.

Community Discussion

No comments yet. Be the first to start the discussion!