exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 9 discussion

Actual exam question from Microsoft's DP-700
Question #: 9
Topic #: 1
[All DP-700 Questions]

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:

Orders -

Customer -

Employee -
The Employee table contains Personally Identifiable Information (PII).
A data engineer is building a workflow that requires writing data to the Customer table, however, the user does NOT have the elevated permissions required to view the contents of the Employee table.
You need to ensure that the data engineer can write data to the Customer table without reading data from the Employee table.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Share Lakehouse1 with the data engineer.
  • B. Assign the data engineer the Contributor role for Workspace2.
  • C. Assign the data engineer the Viewer role for Workspace2.
  • D. Assign the data engineer the Contributor role for Workspace1.
  • E. Migrate the Employee table from Lakehouse1 to Lakehouse2.
  • F. Create a new workspace named Workspace2 that contains a new lakehouse named Lakehouse2.
  • G. Assign the data engineer the Viewer role for Workspace1.
Show Suggested Answer Hide Answer
Suggested Answer: DEF 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Tuki93
4 days, 17 hours ago
Selected Answer: DEF
I think D, E, and F are the working solution.
upvoted 1 times
...
IshtarSQL
6 days, 12 hours ago
Selected Answer: DEF
Why A is incorrect: A. Share Lakehouse1 with the data engineer. Sharing Lakehouse1 directly grants access to all its contents, including the Employee table, which violates the requirement.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago