Implementing Analytics Solutions Using Microsoft Fabric — Question 129

You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table1 contains customer data.

You need to implement row-level security (RLS) for Table1. The solution must ensure that users can see only their respective data.

Which two objects should you create? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Answer options

• A. DATABASE ROLE
• B. STORED PROCEDURE
• C. CONSTRAINT
• D. FUNCTION
• E. SECURITY POLICY

Correct answer: D, E

Explanation

To implement row-level security, you need a FUNCTION that defines the logic for filtering the rows and a SECURITY POLICY that enforces that logic on the table. The other options, such as DATABASE ROLE, STORED PROCEDURE, and CONSTRAINT, do not directly facilitate the row-level security mechanism required in this scenario.