Implementing Data Engineering Solutions Using Microsoft Fabric — Question 51

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?

Answer options

• A. TRIGGER
• B. SCHEMA
• C. FUNCTION
• D. DATABASE ROLE

Correct answer: C

Explanation

The correct answer is C, FUNCTION, because RLS requires the implementation of a function that defines the security policy for accessing rows based on user context. The other options do not directly facilitate the creation of security policies for row-level access, as triggers are for automating actions, schemas organize database objects, and database roles manage permissions rather than implementing RLS.