Which approach allows referencing an external lakehouse location without copying the data?

Prepare for the DP-700 Microsoft Fabric Data Engineer Exam with flashcards and multiple choice questions. Study with hints and explanations, and ensure success on your certification exam!

Multiple Choice

Which approach allows referencing an external lakehouse location without copying the data?

Explanation:
Referencing data where it already resides without duplicating it is achieved by creating a shortcut. A shortcut serves as a lightweight metadata pointer to a dataset located in another lakehouse, so you can query and use the data in place without moving or copying it. This keeps data governance intact, reduces storage costs, and lets you seamlessly reuse external data across lakehouses. The other options involve moving or duplicating data—loading data into a file or into a table—which contradicts the goal of not copying data. An external table can reference data without copying, but a shortcut is the designed mechanism in this context for direct, no-copy access to an external lakehouse location.

Referencing data where it already resides without duplicating it is achieved by creating a shortcut. A shortcut serves as a lightweight metadata pointer to a dataset located in another lakehouse, so you can query and use the data in place without moving or copying it. This keeps data governance intact, reduces storage costs, and lets you seamlessly reuse external data across lakehouses.

The other options involve moving or duplicating data—loading data into a file or into a table—which contradicts the goal of not copying data. An external table can reference data without copying, but a shortcut is the designed mechanism in this context for direct, no-copy access to an external lakehouse location.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy