Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You are creating a new Microsoft Fabric workspace that will host several lakehouses for a sales analytics project. To comply with organizational policies, you must ensure that:
All files written to OneLake in this workspace are stored in the West Europe region.
Workspace consumers must be able to read and query data, but they must NOT be able to download the underlying parquet or CSV files from OneLake.
Which combination of settings should you configure in the OneLake section of the workspace settings to meet both requirements?
Enable OneLake shortcuts and set the Default storage location to West Europe.
Set Default storage location to West Europe and disable the Download files from OneLake toggle.
Change the default file format to Delta and enable personal workspaces only.
Disable the V-Order optimization option and enable item-level security.
In Microsoft Fabric, every workspace has a OneLake section in its settings.
The Default storage location property is used to choose the Azure region where the files that the workspace writes to OneLake will be stored. Selecting West Europe guarantees that any new lakehouse or other OneLake-backed item created in the workspace stores its data in the West Europe OneLake region.
The Download files from OneLake toggle controls whether users who have access to the workspace can download the physical files that back datasets, lakehouses, or other items. Setting this toggle to Disabled blocks file download while still allowing data exploration and queries through Fabric experiences (for example, SQL analytics endpoint or Power BI). Other options-such as turning off the OneLake shortcut feature, changing the default data format, or disabling V-Order optimization-do not affect regional storage or file-download permissions, so they cannot satisfy the requirements.
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 OneLake in Microsoft Fabric?
Open an interactive chat with Bash
Why is the Default storage location important for compliance?
Open an interactive chat with Bash
What does the ‘Download files from OneLake’ toggle do?
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 .