Exam DP-600 topic 1 question 133 discussion

Actual exam question from Microsoft's DP-600

Question #: 133
Topic #: 1

HOTSPOT
-

You have a Fabric tenant that contains the semantic model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by jackjack1 at Jan. 15, 2025, 10:23 p.m.

Comments

Submit Cancel

jackjack1

Highly Voted 5 months, 1 week ago

DirectLakeOnly: All queries use Direct Lake storage mode only. Fall back to DirectQuery mode is disabled. If data can't be loaded into memory, an error is returned.

upvoted 10 times

...

Azure_2023

Highly Voted 3 months, 2 weeks ago

https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-manage#set-the-direct-lake-behavior-property "DirectLakeOnly: All queries use Direct Lake storage mode only. Fall back to DirectQuery mode is disabled. If data can't be loaded into memory, an error is returned." Answer is Direct Lake

upvoted 5 times

...

PradeepikaGadai

Most Recent 1 month, 1 week ago

Direct Lake is the preferred mode. if SQL views are queried from the warehouse, it requires a fallback — because SQL views are not supported in Direct Lake mode so it will fallback to DirectQuery. and Roles (0)means no Row-Level Security (RLS) is configured. No mention of Object-Level Security (OLS) . so its undefined. Direct Query and Undefined.

upvoted 1 times

...

testtaker45

4 months, 3 weeks ago

DirectQuery, Undefined Here is the kicker, if you are in Direct Lake Mode, and see 'Querying SQL', it will fall back to Direct Query. Direct Lake Mode can't handle SQL for various reasons, some being the type of data (likely Parquet), others being Direct Lake mode can't handle SQL Operations like Queries and Aggregations, joins, etc. If you see Direct Lake, and they are talking about SQL, think Direct Query. Good luck everyone -

upvoted 4 times

Chandler9714

3 months, 2 weeks ago

Normally this would be true, but the visual shows that the Direct Lake Behavior is set to Direct Lake Only to ensure fall back to DirectQuery will not occur.

upvoted 4 times

...