This post is a part of the DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric Exam Prep Hub.
This topic falls under these sections:
Implement and manage an analytics solution (30–35%)
   --> Configure Microsoft Fabric workspace settings
      --> Configure OneLake workspace settings

Note that there are 10 practice questions (with answers) at the end of each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available from the hub's main page below the exam topics section.

Introduction

OneLake is one of the foundational components of Microsoft Fabric and is frequently tested on the DP-700 exam. Understanding how OneLake workspace settings are configured and managed is important for Data Engineers because these settings affect data accessibility, governance, security, data sharing, and storage management across Fabric workloads.

Microsoft Fabric was designed around the concept of a single, unified data lake for the entire organization. Rather than having separate storage accounts for different services, OneLake provides a centralized storage layer that serves all Fabric workloads, including:

• Data Engineering
• Data Factory
• Data Warehouse
• Data Science
• Real-Time Intelligence
• Power BI

For the DP-700 exam, you should understand how OneLake workspace settings influence data access, shortcuts, security, governance, and workspace-level administration.

What Is OneLake?

OneLake is Microsoft’s unified, logical data lake for Fabric.

It provides:

• A single storage layer for all Fabric workloads
• Centralized data management
• Open storage formats
• Elimination of data silos
• Simplified data sharing

Every Fabric tenant automatically receives OneLake.

Every Fabric workspace automatically uses OneLake storage.

Unlike traditional Azure architectures where multiple storage accounts may exist, OneLake presents a unified storage experience across the organization.

OneLake Architecture

A useful way to think about OneLake is:

Tenant
│
├── OneLake
│
├── Workspace A
│   ├── Lakehouse
│   ├── Warehouse
│   └── Data Pipelines
│
├── Workspace B
│   ├── Lakehouse
│   ├── Notebooks
│   └── Reports
│
└── Workspace C
    ├── Warehouse
    └── Real-Time Analytics

All data ultimately resides within OneLake.

Workspaces act as organizational containers for Fabric assets.

OneLake Workspace Settings Overview

Workspace administrators can configure several OneLake-related settings.

Common configuration areas include:

• OneLake Data Access
• Shortcut Management
• External Data Connections
• Data Sharing
• Security and Permissions
• Workspace Storage Organization

These settings help control how data is stored, accessed, and shared.

OneLake Security Model

OneLake follows Fabric’s security model.

Security is primarily governed through:

• Workspace roles
• Item-level permissions
• Fabric security groups
• Microsoft Entra ID authentication

OneLake does not introduce a separate security model.

Instead, users access data through Fabric permissions.

For example:

DP-700 Exam Tip

Remember:

OneLake inherits Fabric security.

You do not configure separate OneLake user accounts.

OneLake Shortcuts

One of the most important OneLake workspace settings involves Shortcuts.

Shortcuts allow users to reference data without physically copying it.

Supported sources include:

• Another OneLake location
• Azure Data Lake Storage Gen2
• Amazon S3
• Dataverse
• External cloud storage platforms

Why Shortcuts Matter

Traditional approach:

Source Data
     ↓
Copy
     ↓
Fabric Storage

OneLake Shortcut approach:

Source Data
     ↓
Shortcut
     ↓
Fabric Access

Benefits:

• No data duplication
• Reduced storage costs
• Faster implementation
• Single source of truth

This is one of the most heavily tested OneLake topics on the DP-700 exam.

Managing Shortcut Settings

Workspace administrators may configure:

• Who can create shortcuts
• Which data sources can be referenced
• Governance policies for shortcut usage

Proper shortcut management helps prevent:

• Uncontrolled data sprawl
• Duplicate data sources
• Governance violations

OneLake Data Hub Integration

OneLake works closely with the Data Hub.

The Data Hub allows users to discover:

• Lakehouses
• Warehouses
• Semantic models
• Shared datasets
• Data products

Workspace settings help determine what content becomes discoverable within the organization.

Benefits include:

• Improved discoverability
• Increased data reuse
• Better governance

External Data Access

OneLake can connect to external storage systems.

Common scenarios include:

Azure Data Lake Storage Gen2

Organizations often maintain existing ADLS environments.

OneLake shortcuts allow Fabric to access those files without migration.

Benefits:

• Reduced migration effort
• Faster Fabric adoption
• Single source of truth

Amazon S3

Organizations with multi-cloud environments can create shortcuts to S3 storage.

Benefits:

• Avoid duplicate storage
• Support hybrid cloud architectures
• Simplify analytics workloads

Dataverse

Shortcuts can also reference Dataverse data, making operational business data available within Fabric analytics solutions.

OneLake Data Sharing

OneLake supports organizational data sharing.

Users can share:

• Lakehouses
• Warehouses
• Data products
• Semantic models

Workspace administrators control sharing capabilities through workspace permissions.

Benefits include:

• Increased collaboration
• Improved data reuse
• Reduced duplication

OneLake and Lakehouses

OneLake is particularly important when working with Lakehouses.

Each Lakehouse stores:

• Tables
• Files
• Delta tables

within OneLake storage.

Example:

Workspace
│
└── Lakehouse
    ├── Tables
    └── Files

Physical storage resides in OneLake while Fabric provides the management layer.

OneLake and Data Warehouses

Fabric Warehouses also store their data in OneLake.

Benefits include:

• Unified storage architecture
• Shared governance
• Consistent security

Unlike traditional architectures, lakehouse and warehouse data coexist within the same underlying storage platform.

OneLake File Explorer

Organizations can enable OneLake File Explorer for Windows.

This allows users to:

• Browse OneLake folders
• Access files
• Upload content
• Work with familiar file system interfaces

OneLake File Explorer uses organizational authentication and honors Fabric security settings.

While configuration is generally performed at the tenant level, understanding its relationship to OneLake is useful for the exam.

OneLake Governance Considerations

Good governance practices include:

Minimize Data Duplication

Use shortcuts whenever possible instead of copying data.

Implement Clear Workspace Ownership

Each workspace should have:

• Administrators
• Data Owners
• Data Stewards

Standardize Naming Conventions

Consistent naming improves discoverability and governance.

Control Shortcut Creation

Allowing unrestricted shortcut creation can create governance challenges.

Organizations should establish policies regarding:

• Approved data sources
• Ownership requirements
• Data quality standards

OneLake Workspace Best Practices

Use Shortcuts Instead of Copies

Prefer shortcuts whenever source systems can remain accessible.

Align Workspaces with Business Domains

Organize workspaces around:

• Finance
• Sales
• Operations
• Human Resources

Apply Least-Privilege Access

Grant only the permissions required for users to perform their work.

Promote Reusable Data Assets

Encourage sharing of trusted data products.

Monitor External Data Dependencies

Document all shortcut sources to avoid broken dependencies.

DP-700 Exam Focus Areas

You should be comfortable with:

✓ OneLake architecture

✓ OneLake security model

✓ Workspace-level data access

✓ OneLake shortcuts

✓ External storage integration

✓ Data sharing

✓ Lakehouse storage in OneLake

✓ Warehouse storage in OneLake

✓ Data Hub integration

✓ Governance best practices

Common Exam Scenario

A company stores sales data in Azure Data Lake Storage Gen2 and wants Fabric users to analyze the data without copying it into OneLake.

What should they do?

Answer: Create a OneLake Shortcut to the ADLS Gen2 data.

This scenario appears frequently because Microsoft emphasizes eliminating unnecessary data movement.

10 DP-700 Practice Questions

Question 1

What is the primary purpose of OneLake in Microsoft Fabric?

A. Host Power BI reports

B. Execute Spark workloads

C. Manage workspace permissions

D. Provide a unified storage layer for Fabric workloads

Answer: D

Explanation

OneLake serves as the unified data lake for all Fabric workloads and is the foundational storage layer of the platform.

Incorrect Answers:

• B: Spark workloads run on Spark compute resources.
• C: Permissions are managed through Fabric security roles.
• D: Reports are stored as Fabric items, not hosted by OneLake itself.

Question 2

Which OneLake feature allows access to external data without copying it into Fabric?

A. Lakehouse Replication

B. Delta Synchronization

C. Shortcut

D. Eventstream

Answer: C

Explanation

Shortcuts create references to external data sources while avoiding physical data duplication.

Question 3

A company wants to access Azure Data Lake Storage Gen2 data from Fabric while maintaining a single source of truth.

Which solution should be implemented?

A. Copy the data nightly

B. Create a OneLake Shortcut

C. Export the data to CSV

D. Load the data into a Warehouse

Answer: B

Explanation

A shortcut provides direct access to ADLS Gen2 data without creating duplicate copies.

Question 4

Which security model does OneLake use?

A. Separate OneLake user accounts

B. Local storage permissions

C. SQL authentication

D. Fabric workspace permissions and Microsoft Entra ID

Answer: D

Explanation

OneLake inherits the Fabric security model and uses Microsoft Entra ID for authentication.

Question 5

Which Fabric item stores its underlying data in OneLake?

A. Notebook

B. Dashboard

C. Lakehouse

D. Capacity

Answer: C

Explanation

Lakehouse data is physically stored within OneLake.

Question 6

What is a major benefit of using OneLake Shortcuts?

A. Increased data duplication

B. Reduced storage requirements

C. Automatic data encryption changes

D. Faster Spark startup times

Answer: B

Explanation

Shortcuts reduce storage consumption because data is referenced rather than copied.

Question 7

Which external data source can be accessed through OneLake Shortcuts?

A. Azure Data Lake Storage Gen2

B. Amazon S3

C. Dataverse

D. All of the above

Answer: D

Explanation

OneLake supports shortcuts to multiple external data sources, including ADLS Gen2, S3, and Dataverse.

Question 8

Which Fabric feature improves discoverability of OneLake data assets across the organization?

A. Spark Pools

B. Data Hub

C. Eventhouse

D. Notebook Scheduler

Answer: B

Explanation

The Data Hub enables users to discover and reuse organizational data assets stored in OneLake.

Question 9

A Fabric administrator wants to follow Microsoft-recommended governance practices.

Which approach is preferred?

A. Copy all source data into every workspace

B. Create duplicate Lakehouses

C. Use shortcuts when possible

D. Disable data sharing

Answer: C

Explanation

Microsoft promotes shortcuts as a way to minimize duplication and maintain a single source of truth.

Question 10

Which statement about OneLake and Fabric Warehouses is correct?

A. Warehouses use separate storage outside OneLake.

B. Warehouses cannot share data with Lakehouses.

C. Warehouses require Azure SQL Database storage.

D. Warehouse data is stored in OneLake.

Answer: D

Explanation

Fabric Warehouses use OneLake as their underlying storage layer, providing a unified architecture alongside Lakehouses.

Exam Tip

For the DP-700 exam, the most important OneLake workspace concepts are Shortcuts, unified storage architecture, governance, and security inheritance. If you encounter a scenario that involves accessing data without moving or duplicating it, the correct solution is often a OneLake Shortcut, making it one of the highest-value concepts to master in this objective area.

Go to the DP-700 Exam Prep Hub main page.