DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ5

VerifiedImplement and manage an analytics solution

You have a Fabric workspace containing a warehouse named Warehouse1. Warehouse1 has a table named Customer, which contains the following data.

Question Image

You have an internal Microsoft Entra user named User1 whose email address is [email protected].

You need to grant User1 access to the Customer table while preventing access to the CreditCard column.

How should you complete the statement?

Select
GRANT  ON

Customers(CustomerID, FirstName, LastName, Phone)

TO
Explanation

Fabric Warehouse supports column-level security by granting SELECT on an explicit list of permitted columns. Granting SELECT only for CustomerID, FirstName, LastName, and Phone leaves CreditCard unavailable. A Microsoft Entra user is granted using its email-style principal, [user1@contoso.com].

Learn more

Community Discussion

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