Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You have granted the data-engineering group the Member role on a Microsoft Fabric workspace that contains a Lakehouse named ContosoLH. The Lakehouse stores sensitive CSV files in the path /finance. The group must continue to ingest data into other Lakehouse folders but must be blocked from reading any file that resides under /finance. Which action should you take to meet the requirement without changing the group's workspace role?
Set an Access Control List on the /finance folder in OneLake that removes the group's Read and Execute permissions.
Remove the Build permission for the group on the ContosoLH Lakehouse item.
Create a new Lakehouse for the /finance folder and move the files, then revoke the group's access to that Lakehouse.
Apply dynamic data masking to all tables that reference files in the /finance folder.
In Microsoft Fabric, each Lakehouse is stored in OneLake, which is backed by Azure Data Lake Storage Gen2. You can protect individual folders or files by setting POSIX-style access control lists (ACLs) on the underlying ADLS Gen2 path. Removing (or denying) the Read and Execute permissions for the data-engineering group on the /finance folder prevents the users from listing or opening anything under that path, while their Member role on the workspace continues to let them work in other parts of the Lakehouse.
Denying the Build permission applies at the item level and would block all interaction with the Lakehouse. Dynamic data masking and row-level security apply only to tables exposed through the SQL endpoint and do not restrict file access. Creating a separate Lakehouse and moving data there would change the workspace structure rather than directly enforcing folder-level permissions, and it would still require ACLs or item-level security for isolation.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is an Access Control List (ACL) in the context of Microsoft Fabric?
Open an interactive chat with Bash
How does OneLake integrate with ADLS Gen2 in Microsoft Fabric?
Open an interactive chat with Bash
Why are dynamic data masking and row-level security insufficient for controlling file access in OneLake?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Implement and manage an analytics solution
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .