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

2 months ago

Dual mode could be a possibility too, right?

upvoted 0 times

...

Barabara

2 months ago

I thought it would be DirectQuery.

upvoted 0 times

...

Ressie

3 months ago

Definitely Direct Lake!

upvoted 0 times

...

Destiny

3 months ago

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

upvoted 0 times

...

Janine

3 months ago

Agree, Direct Lake is the way to go here.

upvoted 0 times

...

Dexter

3 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

4 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

4 months ago

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

upvoted 0 times

...

Goldie

4 months ago

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

upvoted 0 times

...

Alonzo

4 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

4 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

5 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

5 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

5 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

9 months 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

9 months 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

7 months ago

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

upvoted 0 times

...

Vinnie

7 months ago

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

upvoted 0 times

...

Nana

8 months ago

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

upvoted 0 times

...

Jesusita

8 months ago

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

upvoted 0 times

...

Stefany

9 months 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

9 months 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

8 months ago

D) Import

upvoted 0 times

...

Emiko

8 months ago

C) Direct Lake

upvoted 0 times

...

Veda

8 months ago

B) Dual

upvoted 0 times

...

Selma

8 months ago

A) DirectQuery

upvoted 0 times

...

Mila

9 months ago

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

upvoted 0 times

...

Willetta

9 months 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

9 months 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

8 months ago

D) Import

upvoted 0 times

...

Glen

9 months ago

A) DirectQuery

upvoted 0 times

...

Isabella

10 months ago

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

upvoted 0 times

...

Dana

10 months ago

I think the answer is A) DirectQuery.

upvoted 0 times

...

Evangelina

10 months 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

9 months 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

9 months ago

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

upvoted 0 times

...

Mabel

9 months 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

9 months 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

9 months ago

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

upvoted 0 times

...

Alisha

10 months ago

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

upvoted 0 times

...