QuestionQ113

VerifiedMaintain a data analytics solution

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.

Choose two
Explanation

Row-level security in a Fabric warehouse follows the same model as SQL Server and Synapse: an inline table-valued FUNCTION defines the predicate that determines which rows a given user is allowed to see, and a SECURITY POLICY binds that function to the target table so the predicate is transparently applied to every query. A database role can help manage which users belong to which group, but on its own it enforces nothing without a bound security policy.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!