Exam DP-600 topic 1 question 28 discussion

A. Direct Query "Row-level security only applies to queries on a Warehouse or SQL analytics endpoint in Fabric. Power BI queries on a warehouse in Direct Lake mode will fall back to Direct Query mode to abide by row-level security." https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security

Direct lake . When users interact with a report built from a Direct Lake semantic model that uses Delta tables and RLS of the warehouse, the DAX queries will operate in Direct Lake mode. This mode is specifically designed for analyzing large data volumes in Power BI and is based on loading parquet-formatted files directly from a data lake without querying a Lakehouse or Warehouse endpoint. Unlike DirectQuery, there is no translation from DAX to other query languages, and it does not execute queries on other database systems. This results in performance similar to import mode, with the added benefit of picking up any changes at the data source as they occur12. Direct Lake mode supports row-level security (RLS), ensuring that users only see the data they have permission to view. It combines the advantages of both DirectQuery and import modes while avoiding their disadvantages, making it an ideal choice for very large models and models with frequent updates at the data source2.

In the scenario, when users interact with a report built from a Direct Lake semantic model that utilizes Delta tables and row-level security (RLS), the DAX queries will primarily operate in Direct Lake mode. So, the correct answer is C. Direct Lake This mode is designed to provide optimal performance for DAX queries, allowing them to read data directly from the Delta tables. However, if there are any limitations or memory pressures, the model may fall back to DirectQuery mode. But under normal circumstances, you can expect the queries to run in Direct Lake mode, leveraging the benefits of RLS effectively

Direct Lake

"When a Direct Lake semantic model table connects to a table in the SQL analytics endpoint that enforces row-level security (RLS), queries that involve that model table will always fall back to DirectQuery mode. Query performance might be slower." The question asks specifically about RLS, so you might already guess that this is a special situation. Always a good idea to look it up in the Fabric documentation if you've never seen this specific case. Reference: https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview

"When a Direct Lake semantic model table connects to a table in the SQL analytics endpoint that enforces row-level security (RLS), queries that involve that model table will always fall back to DirectQuery mode. Query performance might be slower." The question asks specifically about RLS, so you might already guess that this is a special situation. Always a good idea to look it up in the Fabric documentation if you've never seen this specific case. Reference: https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview

C. Direct Lake mode is a specific feature of Microsoft Fabric that allows Power BI to directly access Delta tables in a Fabric Lakehouse or Warehouse without needing to import data into Power BI or rely on DirectQuery alone. This mode enables real-time interaction with the data stored in the lake without additional overhead. DirectQuery would be more relevant if the data were in a database that supported DirectQuery rather than Delta tables in Fabric's Lakehouse/Warehouse.

C) In fabric, its always the DirectLake mode

Because it says "RLS of the warehouse" I'd be more likely to go for DirectQuery than Direct Lake

A. Direct lake - Row-level security only applies to queries on a Warehouse or SQL analytics endpoint in Fabric. Power BI queries on a warehouse in Direct Lake mode will fall back to Direct Query mode to abide by row-level security.

Its A. Based on https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security

Both DirectQuery and DirectLake support RLS.The key word here is that tenant already had a Semantic Warehouse built.To query that one you need to use DirectQuery.Therefore the answer is A.But for the real user they can use DirectLake as well hear sinc eboth of them support RLS.Answer is A for this question.Thank you.

Selected Answer: D D. https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview On the other hand, with import mode, performance can be better because the data is cached and optimized for DAX and MDX report queries without having to translate and pass SQL or other types of queries to the data source.

c in my opinion

C. https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview "Before using Direct Lake, you must provision a lakehouse (or a warehouse) with one or more Delta tables in a workspace...Direct Lake also supports row-level security and object-level security so users" And it is Fabric exam, so the obvious correct answers is a Fabric feature.

Direct Lake mode is a new feature in Power BI that allows direct querying of Delta tables in a data lake without the need to import data into the Power BI model. This mode "combines" the advantages of DirectQuery and Import modes, providing real-time access to data while leveraging the performance benefits of in-memory caching for certain queries.

While Direct Lake mode doesn't query the SQL endpoint when loading data directly from OneLake, it's required when a Direct Lake model must seamlessly fall back to DirectQuery mode, such as when the data source uses specific features like advanced security or views that can't be read through Direct Lake.