Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 92 discussion

Actual exam question from Microsoft's DP-600
Question #: 92
Topic #: 1
[All DP-600 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
neoverma
Highly Voted 7 months, 3 weeks ago
https://learn.microsoft.com/en-us/power-bi/enterprise/directlake-overview#fallback-behavior The DirectLakeBehavior property can be configured by using Tabular Object Model (TOM) or Tabular Model Scripting Language (TMSL). The following example specifies all queries use Direct Lake mode only: C# Copy // Disable fallback to DirectQuery mode. // database.Model.DirectLakeBehavior = DirectLakeBehavior.DirectLakeOnly = 1; database.Model.SaveChanges();
upvoted 8 times
...
554b579
Highly Voted 7 months, 3 weeks ago
Click on Semantic model. In the Properties pane, choose the Direct Lake behavior for your custom Direct Lake semantic model: Automatic: This is the default behavior. It allows Direct Lake with fallback to DirectQuery mode if data can’t be efficiently loaded into memory. Direct Lake only: This option ensures no fallback to DirectQuery mode https://powerbi.microsoft.com/en-au/blog/leveraging-pure-direct-lake-mode-for-maximum-query-performance/
upvoted 5 times
...
Ous01
Most Recent 3 days, 19 hours ago
In Tabular Editor version 3, it is possible to change the Default Mode to Direct Lake and it will be the right answer. Now I am confused with this question as TE version 2.5 does not allow the Default Mode of Direct Lake, so the only option is the Direct Lake Behavior.
upvoted 1 times
...
FSCH_111
5 months ago
Selected Answer: D
The correct option to ensure queries use Direct Lake mode in Tabular Editor is: D. From Model, configure the Direct Lake Behavior option. Here's why the other options are incorrect: A. Default Mode: This option doesn't exist specifically for Direct Lake mode. It might be related to a different setting within the model. B. Partitions: Partitions are used to manage data refresh in large models, not to define the overall query mode. C. Storage Location: This option specifies where the model metadata is stored, not the data retrieval method.
upvoted 1 times
...
stilferx
6 months, 2 weeks ago
Selected Answer: D
IMHO, D, Because: Direct Lake models include the DirectLakeBehavior property, which has three options: ... **DirectLakeOnly** - Specifies all queries use Direct Lake mode only. Fallback to DirectQuery mode is disabled. If data can't be loaded into memory, an error is returned. Use this setting to determine if DAX queries fail to load data into memory, forcing an error to be returned. ... The DirectLakeBehavior property can be configured by using Tabular Object Model (TOM) or Tabular Model Scripting Language (TMSL). Link: https://learn.microsoft.com/en-us/power-bi/enterprise/directlake-overview#fallback-behavior
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...