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…

Stored procedures are used for encapsulating SQL statements and logic, but they are not directly used as security predicates for RLS.

Constraints enforce data integrity rules (e.g., primary key, foreign key, check constraints) but do not filter data rows based on user identity for security purposes.

Schemas are used to organize database objects, but they do not define the filtering logic for RLS.

RLS in a Fabric warehouse is implemented by creating a security policy that uses an inline table-valued function (ITVF) as a predicate. This function contains the logic to filter rows based on criteria like the current user's identity, ensuring that users only see authorized data.