Exam DP-700 topic 1 question 55 discussion

Actual exam question from Microsoft's DP-700

Question #: 55
Topic #: 1

HOTSPOT
-

You have a Fabric workspace that contains a warehouse named Warehouse1. Warehouse1 contains a table named Customer. Customer contains the following data.

You have an internal Microsoft Entra user named User1 that has an email address of [email protected].

You need to provide User1 with access to the Customer table. The solution must prevent User1 from accessing the CreditCard column.

How should you complete the statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by 5e89616 at April 9, 2025, 6:48 a.m.

Comments

Submit Cancel

12a2ecc

3 weeks ago

answer should be GRANT SELECT ON Customers(CustomerID, FirstName, LastName, Phone) TO [[email protected]] https://learn.microsoft.com/en-us/fabric/data-warehouse/column-level-security

upvoted 4 times

...

Biju1

3 weeks, 3 days ago

GRANT SELECT ON Customers(CustomerID, FirstName, LastName, Phone) TO [[email protected]] is corrected. I tested

upvoted 3 times

...

zxc01

3 weeks, 3 days ago

answer should be GRANT SELECT ON Customers(CustomerID, FirstName, LastName, Phone) TO [[email protected]]

upvoted 4 times

12a2ecc

3 weeks ago

Correct, since Entra user: https://learn.microsoft.com/en-us/fabric/data-warehouse/column-level-security

upvoted 1 times

...

5e89616

3 weeks, 5 days ago

Correct. GRANT SELECT ON Customers(CustomerID, FirstName, LastName, Phone) TO [User1] Alternatively: DENY SELECT ON Customers(CreditCard) TO [User1]

upvoted 3 times

...

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 55 discussion

Comments

12a2ecc

Biju1

zxc01

12a2ecc

5e89616

SY0-701