Implementing Data Engineering Solutions Using Microsoft Fabric — Question 52

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. SECURITY POLICY
• B. TABLE
• C. TRIGGER
• D. STORED PROCEDURE

Correct answer: A

Explanation

The correct answer is A, SECURITY POLICY, which is specifically designed to implement row-level security by defining access rules for specific users or roles. The other options, such as TABLE, TRIGGER, and STORED PROCEDURE, do not provide the necessary functionality to enforce RLS directly.