You work as a Security Architect for Mark at MDFT Pro, a well-known training agency. MDFT Pro operates a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. This lakehouse stores three critical tables: Orders, Customer, and Employee. The Employee table contains Personally Identifiable Information (PII) including social security numbers, home addresses, and salary information that must be protected according to data privacy regulations. Claire, a data engineer at MDFT Pro, is building a workflow that requires writing enrollment updates to the Customer table. However, company security policy strictly prohibits Claire from having access to view the contents of the Employee table due to the sensitive PII it contains. Mark has asked you to implement a security solution that allows Claire to write data to the Customer table while ensuring she cannot read any data from the Employee table.
Which three actions should you perform?
Choose all correct answers from the options below.
Explanations for each answer: