Objective 2.2

DP-700

Ingest and transform batch data

Objective 2.2 sits in Ingest and transform data, which carries 33% of the DP-700 Fabric Data Engineer exam. The questions below are original, written from the official objective title above, and each explanation cites the Microsoft Azure page it rests on.

Objective title verbatim from the official objectives. Microsoft Azure exam page

A worked example

Shown solved, with the whole explanation open: this is what every question here carries.

2-2Ingest and transform data

You want live access to an ADLS Gen2 folder inside a lakehouse without copying the data. Which OneLake feature do you use?

A pipeline copy activityCopy activity duplicates the data.
A dataflowA dataflow ingests and prepares a copy.
A warehouse CTASCTAS creates a new table copy.
A shortcutCorrect · your answerCorrect.

Correct.

Concept

Shortcuts point to other storage locations so data is referenced in place rather than duplicated into the lakehouse.

Why D

A shortcut is an object in OneLake that points to another storage location without copying data.

Source

Shortcuts are objects in OneLake that point to other storage locations.

Microsoft Learn, OneLake shortcuts, checked August 2026
#2-2

Now you: objective 2.2 questions

No account needed. The explanation opens when you answer.

Sample question 1 of 3

2-2Ingest and transform data

With Fabric database mirroring, how frequently can source changes be published to the target Delta table?

Sample question 2 of 3

2-2Ingest and transform data

You buy an F64 capacity and enable mirroring. How much free mirroring storage do you get?

Sample question 3 of 3

2-2Ingest and transform data

You want to reference Azure Databricks Unity Catalog data in Fabric without moving it, syncing only catalog structure. Which mirroring type applies?

That’s 3 of the full DP-700 Fabric Data Engineer bank.

Keep going free: 10 questions per certification in bank practice, with no account.

Continue practising

Read the sources

These are the official pages the questions above cite. Reading them is studying the objective from the primary source, which is what the explanations point you toward anyway.

More objectives in Ingest and transform data