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:
Ingest and transform data (30–35%)
   --> Ingest and transform streaming data
      --> Choose between Query Acceleration for OneLake shortcuts and standard OneLake shortcuts in Real-Time Intelligence

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

Microsoft Fabric provides multiple ways to access data stored in OneLake from Real-Time Intelligence workloads such as Eventhouses and KQL databases. One of the most important design decisions for data engineers is determining whether to use:

• Standard OneLake shortcuts
• Query-accelerated OneLake shortcuts

Understanding the differences between these options is essential for the DP-700 exam because they directly affect performance, cost, latency, storage consumption, and analytics architecture.

This article explains how each option works, when to use them, their limitations, and the decision-making criteria you should understand for the exam.

Understanding OneLake Shortcuts

A OneLake shortcut is a virtual reference to data stored elsewhere. Instead of copying data, the shortcut points to an existing data source. This allows multiple Fabric experiences to access the same data without creating duplicate copies. (Microsoft Learn)

For example:

• A Lakehouse contains sales data.
• An Eventhouse creates a shortcut to that data.
• Queries can access the data through the shortcut.
• The original data remains in its source location.

Benefits include:

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

Standard OneLake Shortcuts

A standard OneLake shortcut allows Real-Time Intelligence workloads to query external data directly from OneLake without ingesting it into the Eventhouse. (Microsoft Learn)

How It Works

When a query executes:

1. Eventhouse accesses the shortcut.
2. Data is retrieved from the source Delta table.
3. Results are returned to the query.

No additional indexing or caching is performed.

Advantages

• Minimal setup effort
• No duplicated storage
• Lower cost
• Immediate access to existing data
• Suitable for infrequent queries

Disadvantages

• Slower query performance
• Higher query latency
• External storage access required during execution
• Limited optimization opportunities

Query Acceleration for OneLake Shortcuts

Query Acceleration is a feature in Real-Time Intelligence that improves query performance against OneLake shortcut data by automatically caching and indexing selected data. (Video2 Skills Academy)

Instead of repeatedly reading Delta files from storage, Fabric creates optimized structures that significantly improve performance.

How It Works

When acceleration is enabled:

1. A shortcut is created.
2. Fabric indexes the data.
3. Fabric caches data based on the configured retention period.
4. Queries use optimized structures instead of repeatedly scanning raw files. (Microsoft Learn)

The experience becomes similar to querying native Eventhouse data.

Query Acceleration Architecture

Without acceleration:

Delta Table
      ↓
OneLake Shortcut
      ↓
Query Reads Files Directly

With acceleration:

Delta Table
      ↓
OneLake Shortcut
      ↓
Indexing and Caching
      ↓
High-Performance Queries

Performance Comparison

When to Use Standard OneLake Shortcuts

Choose standard shortcuts when:

Query Frequency is Low

If users only occasionally access the data, acceleration may not provide sufficient value.

Example:

• Monthly compliance reports
• Ad hoc investigations
• Occasional auditing

Cost Optimization is Critical

Since acceleration introduces caching and indexing costs, standard shortcuts are often preferred for budget-sensitive workloads.

Data Volumes are Small

Smaller datasets generally perform well enough without acceleration.

When to Use Query Acceleration

Choose query acceleration when:

High Query Volume Exists

Examples:

• Interactive dashboards
• Continuous monitoring
• Frequent analytics workloads

Large Delta Tables Are Queried

Large historical datasets often benefit significantly from acceleration.

Real-Time and Historical Data Must Be Combined

A common Real-Time Intelligence pattern involves:

• Streaming data arriving in Eventhouse
• Historical data stored in OneLake

Query acceleration enables efficient joins between both datasets. (Video2 Skills Academy)

Example:

Live Sensor Stream
        +
Historical Equipment Data
        =
Real-Time Analytics

Dimension Data Must Be Joined Frequently

Organizations often mirror dimension data into OneLake and then use accelerated shortcuts for enrichment and lookup operations. (Video2 Skills Academy)

Configuring Query Acceleration

Acceleration can be enabled:

• During shortcut creation
• After shortcut creation through Data Policies settings (Microsoft Learn)

Administrators can also define:

• Number of cached days
• Retention period
• Acceleration policies

The caching period determines how much data remains optimized for high-performance access. (Microsoft Learn)

Caching Period Considerations

The caching period directly impacts:

• Query performance
• Storage consumption
• Cost

Example:

Longer periods improve performance across larger time ranges but increase storage costs.

Cost Considerations

This topic frequently appears in architecture-based exam questions.

Standard Shortcuts

Costs include:

• Storage
• Query processing

No additional acceleration charges apply.

Query Acceleration

Additional costs include:

• Cached data storage
• Index maintenance
• Acceleration processing (Video2 Skills Academy)

The tradeoff is:

Higher Cost
      ↓
Much Better Performance

Limitations of Query Acceleration

Candidates should understand major limitations.

Examples include: (Video2 Skills Academy)

• Materialized views are not supported.
• Update policies are not supported.
• External tables with extremely large file counts may experience reduced effectiveness.
• Certain Delta table schema changes may require reacceleration.
• Some advanced Delta features may require disabling and re-enabling acceleration.

Decision Framework for the Exam

A useful exam strategy:

Choose Standard Shortcuts When

• Cost is the highest priority.
• Data is queried infrequently.
• Data volume is moderate.
• Performance requirements are relaxed.

Choose Query Acceleration When

• Performance is critical.
• Queries occur frequently.
• Large datasets are analyzed.
• Historical and streaming data are combined.
• Interactive analytics workloads exist.

DP-700 Exam Tips

Remember These Key Points

1. OneLake shortcuts avoid data duplication.
2. Standard shortcuts access data directly.
3. Query acceleration adds indexing and caching.
4. Query acceleration improves performance but increases cost.
5. Accelerated shortcuts are ideal for frequent analytical queries.
6. Standard shortcuts are ideal for occasional access scenarios.
7. Query acceleration is especially valuable when combining streaming and historical datasets.
8. Cached retention periods directly affect cost and performance.
9. Accelerated shortcuts behave like external tables and inherit some external table limitations.
10. The exam often focuses on choosing the most cost-effective versus highest-performance solution.

Practice Exam Questions

Question 1

A company uses Eventhouse to analyze telemetry data. Historical data resides in OneLake and is queried thousands of times per day. Query performance is poor.

What should you implement?

A. Dataflows Gen2
B. Query acceleration on the OneLake shortcut
C. Warehouse mirroring
D. Notebook scheduling

Correct Answer: B

Explanation:
Query acceleration adds indexing and caching that significantly improves query performance for frequently accessed shortcut data. (Video2 Skills Academy)

Question 2

What is the primary benefit of a standard OneLake shortcut?

A. Eliminates all query latency
B. Automatically indexes data
C. Provides access to data without duplication
D. Creates materialized views

Correct Answer: C

Explanation:
Shortcuts reference existing data rather than copying it, allowing a single source of truth. (Microsoft Learn)

Question 3

A solution prioritizes the lowest possible storage and acceleration costs. Data is queried only once per month.

Which option should be selected?

A. Query-accelerated shortcut
B. Materialized view
C. Standard OneLake shortcut
D. Native Eventhouse ingestion

Correct Answer: C

Explanation:
When query frequency is very low, the additional acceleration costs are generally not justified.

Question 4

What additional capability does query acceleration provide?

A. Encryption
B. Data mirroring
C. Row-level security
D. Caching and indexing

Correct Answer: D

Explanation:
Query acceleration improves performance through indexing and caching. (Video2 Skills Academy)

Question 5

Which scenario most strongly justifies query acceleration?

A. Small dataset queried quarterly
B. Development environment testing
C. Large historical dataset used in interactive dashboards
D. One-time data migration

Correct Answer: C

Explanation:
Interactive dashboards require low latency and frequent queries, making acceleration highly beneficial.

Question 6

What happens to the source data when a OneLake shortcut is created?

A. It is copied into Eventhouse
B. It is archived
C. It is compressed
D. It remains in its original location

Correct Answer: D

Explanation:
A shortcut is only a reference to the original data source. (Microsoft Learn)

Question 7

An engineer wants to join streaming Eventhouse data with historical OneLake data while maintaining high query performance.

Which approach should be recommended?

A. Query-accelerated shortcut
B. Dataflow Gen2
C. Warehouse endpoint
D. Manual exports

Correct Answer: A

Explanation:
One of the primary use cases for query acceleration is combining streaming and historical data efficiently. (Video2 Skills Academy)

Question 8

What configuration primarily controls how much accelerated data remains cached?

A. Workspace role assignments
B. Retention and caching period settings
C. Lakehouse schema definitions
D. Fabric tenant settings

Correct Answer: B

Explanation:
Administrators specify how many days of data are retained in the acceleration cache. (Microsoft Learn)

Question 9

Which statement about accelerated shortcuts is true?

A. They always cost less than standard shortcuts.
B. They require data duplication.
C. They can improve performance through cached and indexed data.
D. They eliminate storage requirements.

Correct Answer: C

Explanation:
Acceleration works by indexing and caching data while still avoiding data duplication. (Video2 Skills Academy)

Question 10

A company needs the fastest possible query performance against frequently accessed OneLake data and is willing to accept additional cost.

Which option should be chosen?

A. Standard OneLake shortcut
B. Manual exports to CSV
C. Dataflow Gen2
D. Query-accelerated OneLake shortcut

Correct Answer: D

Explanation:
Query acceleration is specifically designed to maximize query performance by using caching and indexing mechanisms. (Video2 Skills Academy)

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