DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ40

VerifiedImplement and manage an analytics solution

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1.

You need to ensure that a user named User1 can view only specific rows in Table1.

What should you do first?

Explanation

Row-level security in SQL Server/Fabric requires first creating a table-valued function that defines the security predicate logic. The security policy is then created referencing this function. Granting permissions comes last. Creating a predicate before a function reverses the correct sequence.

Community Discussion

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