Question
You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives.
You plan to implement row-level security (RLS).
You need to ensure that the sales representatives can see only their respective data.
Which warehouse object do you require to implement RLS?
- A. STORED PROCEDURE
- B. CONSTRAINT
- C. SCHEMA
- D. FUNCTION Correct
Explanation
Row-level security in a Fabric warehouse uses an inline table-valued function as the filter predicate, which a security policy (CREATE SECURITY POLICY) then binds to the table. The function returns rows only when the current user, for example USER_NAME(), matches the sales representative column. Stored procedures, constraints, and schemas cannot filter which rows a user sees. A schema is often used to keep the RLS objects together, but RLS does not depend on it.
