MDFT Pro, a well-known training agency, has 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?
FUNCTION is correct. Functions contain the predicate logic that filters rows based on the current user context, which is required for RLS implementation.
CONSTRAINT is incorrect. Constraints enforce data integrity rules, not row-level access control based on user identity.
STORED PROCEDURE is incorrect. Stored procedures execute SQL batches but don't provide the predicate function needed for row-level security filtering.
SCHEMA is incorrect. Schemas organize database objects into namespaces but don't filter rows based on user identity.