Answer-first summary for fast verification
Answer: FUNCTION, SECURITY POLICY
To implement Row-Level Security (RLS) in Microsoft Fabric Warehouse, you need to create two objects: a FUNCTION to define the security predicate that filters rows based on user identity (e.g., using USER_NAME() or SUSER_SNAME()), and a SECURITY POLICY to apply this function to the target table (Table1). This approach is supported by Microsoft documentation and aligns with the community consensus, where DE has 78% support and detailed explanations highlight that the function defines the filtering logic while the security policy enforces it. Options A (DATABASE ROLE) and B (STORAGE PROCEDURE) are incorrect because RLS does not require creating new roles or stored procedures; existing roles can be used in the function logic, but roles themselves are not created as part of RLS setup. Option C (CONSTRAINT) is unrelated to RLS and deals with data integrity.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have a Fabric warehouse named Warehouse1 containing a table named Table1 with customer data.
You need to implement row-level security (RLS) on Table1 so that users can only view their own data.
Which two objects should you create? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A
DATABASE ROLE
B
STORED PROCEDURE
C
CONSTRAINT
D
FUNCTION
E
SECURITY POLICY