Microsoft Fabric Data Engineer Associate DP-700 Practice Question
A Microsoft Fabric workspace contains several items, including a Lakehouse named FinanceLH that stores confidential payroll data. Only a group of external auditors must be able to run ad-hoc SQL queries against FinanceLH, and they must not see or modify any other items in the workspace. You need to grant the auditors the minimum access required to meet the requirement.
Which action should you take?
Assign the auditors the Viewer role for the workspace that contains FinanceLH.
Publish FinanceLH to a separate workspace by using a deployment pipeline and assign the auditors the Member role in that workspace.
Open Manage permissions for FinanceLH and grant the auditors Read permission on the Lakehouse.
Add the auditors to the Contributor role for the workspace and enable the Use SQL endpoint option on FinanceLH.
Granting the auditors Read permission on the Lakehouse by using Manage permissions limits their access to that single item. The Read permission lets them query data (through the SQL endpoint or shortcuts) but prevents changes to tables, notebooks, or other item properties and does not expose other workspace items.
Assigning the Viewer role at the workspace level would give read access to every item in the workspace, violating the "minimum access" requirement. The Contributor role would also allow the auditors to add or change items. Creating another workspace and deployment pipeline adds unnecessary overhead and still gives broader permissions than required. Therefore, item-level Read permission on FinanceLH is the most restrictive and appropriate solution.
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 the SQL endpoint in Microsoft Fabric Lakehouse?
Open an interactive chat with Bash
What is the difference between the Viewer role and Read permission?
Open an interactive chat with Bash
Why is enabling Contributor-level access inappropriate in this scenario?
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 .