Microsoft DP-600 Exam - Topic 3 Question 36 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 36
Topic #: 3

You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS). You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse. When users interact with a report built from the model, which mode will be used by the DAX queries?

ADirectQuery

BDual

CDirect Lake

DImport

Show Suggested Answer

Suggested Answer: A

When users interact with a report built from a Direct Lake semantic model that uses row-level security (RLS), the DAX queries will operate in DirectQuery mode (A). This is because the model directly queries the underlying data source without importing data into Power BI. Reference = The Power BI documentation on DirectQuery provides detailed explanations of how RLS and DAX queries function in this mode.

by Carlee at May 04, 2025, 05:42 AM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lucy

9 months ago

Dual mode could be a possibility too, right?

upvoted 0 times

...

Barabara

9 months ago

I thought it would be DirectQuery.

upvoted 0 times

...

Ressie

9 months ago

Definitely Direct Lake!

upvoted 0 times

...

Destiny

9 months ago

Wait, are we sure about that? Sounds too easy.

upvoted 0 times

...

Janine

9 months ago

Agree, Direct Lake is the way to go here.

upvoted 0 times

...

Dexter

10 months ago

I’m confused about the differences between Direct Lake and DirectQuery. I need to double-check how RLS affects those modes.

upvoted 0 times

...

Staci

10 months ago

I practiced a similar question last week, and I feel like it was about how RLS interacts with different modes. I might lean towards A or C.

upvoted 0 times

...

Tonette

10 months ago

I'm not entirely sure, but I remember something about DirectQuery being used with RLS in other scenarios.

upvoted 0 times

...

Goldie

10 months ago

I think the answer might be C, Direct Lake, since it specifically mentions using Delta tables and RLS.

upvoted 0 times

...

Alonzo

10 months ago

This is a tricky one. The key seems to be understanding how Direct Lake models handle query modes. I'm not 100% sure, but I think I'll go with C. Direct Lake as the best answer.

upvoted 0 times

...

Nu

11 months ago

I'm leaning towards B. Dual. The question mentions the model uses RLS, and Dual mode can handle row-level security, right? I'll double-check the details, but that's my initial thought.

upvoted 0 times

...

Kenneth

11 months ago

Okay, let me break this down. We have a Direct Lake model that uses Delta tables and RLS. That means the data is coming directly from the data source, not imported. So I think the answer is A. DirectQuery.

upvoted 0 times

...

Malcom

11 months ago

Hmm, I'm a bit confused. The question talks about row-level security, but I'm not sure how that relates to the query mode. I'll have to think this through carefully.

upvoted 0 times

...

Brett

11 months ago

This one seems straightforward. The question mentions a Direct Lake semantic model, so I'm guessing the answer is C. Direct Lake.

upvoted 0 times

...

Corrinne

1 year ago

I bet the answer is C) Direct Lake. It's like the Hogwarts of data models - direct, yet still a lake. Makes perfect sense to me!

upvoted 0 times

...

Emmanuel

1 year ago

Hmm, this is a tough one. I'm gonna go with B) Dual, just to be safe. That way, I can cover my bases no matter what mode the DAX queries use.

upvoted 0 times

Edelmira

1 year ago

User 4: I agree with Nana, A) DirectQuery seems like the right choice.

upvoted 0 times

...

Vinnie

1 year ago

User 3: I believe it's D) Import.

upvoted 0 times

...

Nana

1 year ago

User 2: I'm not sure, but I'll go with C) Direct Lake.

upvoted 0 times

...

Jesusita

1 year ago

User 1: I think the correct answer is A) DirectQuery.

upvoted 0 times

...

Stefany

1 year ago

I'm going with A) DirectQuery. Why bother with all that fancy-shmancy 'Direct Lake' business when you can just query the data directly? Keeps things simple, you know?

upvoted 0 times

...

Lynelle

1 year ago

C) Direct Lake, obviously. I mean, the question literally says 'Direct Lake semantic model', so that has to be the answer, right?

upvoted 0 times

Elin

1 year ago

D) Import

upvoted 0 times

...

Emiko

1 year ago

C) Direct Lake

upvoted 0 times

...

Veda

1 year ago

B) Dual

upvoted 0 times

...

Selma

1 year ago

A) DirectQuery

upvoted 0 times

...

Mila

1 year ago

I think the correct answer is A) DirectQuery because it directly queries the data source without importing it.

upvoted 0 times

...

Willetta

1 year ago

I'm not sure, but I think C) Direct Lake could also be a possibility since it's mentioned in the question.

upvoted 0 times

...

Chantell

1 year ago

D) Import seems like the most logical choice here. Surely we wouldn't want to query the Delta tables directly, that could be risky!

upvoted 0 times

Elliot

1 year ago

D) Import

upvoted 0 times

...

Glen

1 year ago

A) DirectQuery

upvoted 0 times

...

Isabella

1 year ago

I disagree, I believe the answer is B) Dual because it combines both DirectQuery and Import modes.

upvoted 0 times

...

Dana

1 year ago

I think the answer is A) DirectQuery.

upvoted 0 times

...

Evangelina

1 year ago

I'm pretty sure the correct answer is B) Dual. The question mentions the use of Delta tables and RLS, which suggests a mix of import and DirectQuery modes.

upvoted 0 times

Howard

1 year ago

I'm not sure, but C) Direct Lake could also be a possibility considering the setup of the warehouse and the Direct Lake semantic model.

upvoted 0 times

...

Malcom

1 year ago

I agree, A) DirectQuery seems like the right choice based on the scenario described.

upvoted 0 times

...

Mabel

1 year ago

I think the correct answer is A) DirectQuery. It makes sense with the setup of Delta tables and RLS in the warehouse.

upvoted 0 times

...

Eileen

1 year ago

I agree with you, it must be B) Dual. The question implies a mix of import and DirectQuery for the DAX queries.

upvoted 0 times

...

Florencia

1 year ago

I believe it's B) Dual. The combination of import and DirectQuery modes fits with the scenario described.

upvoted 0 times

...

Alisha

1 year ago

I think the correct answer is A) DirectQuery. It makes sense with the use of Delta tables and RLS.

upvoted 0 times

...