Implementing Data Engineering Solutions Using Microsoft Fabric — Question 9

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. STORED PROCEDURE
• B. CONSTRAINT
• C. SCHEMA
• D. FUNCTION

Correct answer: D

Explanation

The correct answer is D, FUNCTION, because a function can be used to define the logic for row-level security, allowing dynamic access control based on the user. The other options, such as STORED PROCEDURE, CONSTRAINT, and SCHEMA, do not provide the necessary mechanism to enforce RLS in this context.