Microsoft Fabric Data Engineer Associate DP-700 Practice Question
Your Microsoft Fabric workspace contains a Lakehouse named ContosoSales with two top-level folders: /Sales and /HR. All members of the "Sales-Analysts" Microsoft Entra security group are assigned the Contributor role at the workspace level so that they can create and modify tables under /Sales. You must ensure that those users cannot read, query, or download any files that reside in the /HR folder while keeping their current permissions on the rest of the Lakehouse. Which action should you perform to meet the requirement?
Move the /HR folder to a new Lakehouse in a separate workspace and grant access only to HR personnel.
Create a row-level security policy that filters out all rows from tables stored in the /HR folder for the Sales-Analysts group.
Downgrade the Sales-Analysts group to the Viewer role at the workspace level and grant explicit write permissions only on the /Sales folder.
Edit the Access Control List (ACL) on the /HR folder in the Lakehouse and remove the Sales-Analysts group's inherited Lakehouse permissions.
Folder- and file-level permissions in OneLake are enforced through Access Control Lists (ACLs). Because the Sales-Analysts group already has Contributor rights at the workspace level, they inherit read/write access to every object in the Lakehouse. You can override this inheritance by opening the Access pane for the /HR folder and removing the group's default Lakehouse permissions (or explicitly denying Read and Execute). This prevents the users from opening or querying anything in /HR while leaving their existing rights on /Sales unchanged. Changing the workspace role would reduce their ability to manage objects in /Sales. Row-level security and dynamic data masking operate at the table level after data is loaded and do not prevent users from listing or downloading the underlying files. Moving the folder to a separate Lakehouse is unnecessary because fine-grained ACLs already provide the required 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 are Access Control Lists (ACLs) in Microsoft Fabric Lakehouse?
Open an interactive chat with Bash
Why is Row-Level Security (RLS) not appropriate for file-level restrictions in this scenario?
Open an interactive chat with Bash
What is the difference between overriding ACL permissions and changing workspace roles?
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 .