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?
When users interact with a report built from a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse, the DAX queries will use the DirectQuery mode. This is because, in Fabric, row-level security (RLS) is enforced at the query level and requires DirectQuery to ensure the appropriate data is accessed dynamically from the warehouse for each user.
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.
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.
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.
A. https://fabric.guru/power-bi-direct-lake-mode-frequently-asked-questions
What the heck is "Import" in DAX? Its DirectQuery only.
Probably a reference to table types in PBI where import is commonly used
Dax and fallback its direct query
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
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
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.
ChatGPT says the answer is C- Direct Lake
A if the semantic model has direct lake connection to the source, then the report connecting to this semantic model has direct query.
A as has been shared before https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security
Power BI queries on a warehouse in Direct Lake mode will fall back to Direct Query mode to abide by row-level security.