Implementing Data Engineering Solutions Using Microsoft Fabric — Question 3

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.

Answer options

• 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.

Correct answer: D, E, F

Explanation

The correct steps are to assign the Contributor role for Workspace1 (D), migrate the Employee table to a new lakehouse (E), and create a new workspace with the new lakehouse (F). This allows the data engineer to write to the Customer table without accessing sensitive PII in the Employee table, while the other options either grant unnecessary permissions or do not address the requirement effectively.