BenchMark Quizzes by MDFT Pro

Choose the Query Mode for RLS

You work as a data analyst for MDFT Pro, a well-known training agency. The academy has a Fabric tenant that contains a warehouse for storing student enrollment data. The warehouse uses row-level security (RLS) to ensure trainers can only access data for their assigned students.

You create a semantic model that uses the student enrollment data tables and RLS of the warehouse. When trainers interact with a report built from the model, which mode will be used by the DAX queries?

Choose the correct answer from the options below.

Explanations for each answer:

DirectQuery is correct.
Dual is incorrect. Dual mode enables switching between Import and DirectQuery for performance, but when RLS is enforced at the source, only DirectQuery is used to preserve security.
Direct Lake is incorrect. Direct Lake mode is used for reading Delta tables directly from OneLake. It does not support RLS enforcement and is bypassed when RLS is active.
Import is incorrect. Import mode stores data in-memory and cannot enforce row-level security defined in the source system, such as a Fabric warehouse.

Learn more about Row-Level Security in Fabric:

Row-Level Security

Exam Preparation Quiz

Choose the Query Mode for RLS