DP-600 · Question #178
You have a Fabric tenant named Tenant1 that contains a lakehouse named Lakehouse1. You need to add data to Lakehouse1 from a CSV file in an Azure Storage account outside of Fabric. The solution must…
The correct answer is B. shortcut. To add data from an external Azure Storage account to a Fabric Lakehouse with minimal development effort, a shortcut is the most efficient method as it directly links to the data without requiring ingestion.
Question
You have a Fabric tenant named Tenant1 that contains a lakehouse named Lakehouse1. You need to add data to Lakehouse1 from a CSV file in an Azure Storage account outside of Fabric. The solution must minimize development effort. What should you use to add the data?
Options
- Acopy job
- Bshortcut
- Cpipeline
- DDataflow Gen2
How the community answered
(36 responses)- A14% (5)
- B78% (28)
- C3% (1)
- D6% (2)
Why each option
To add data from an external Azure Storage account to a Fabric Lakehouse with minimal development effort, a shortcut is the most efficient method as it directly links to the data without requiring ingestion.
A copy job (or a Copy Data activity within a pipeline) would involve defining the source and destination, and then explicitly copying the data, which requires more configuration and effort than simply creating a direct link via a shortcut.
Creating a shortcut in Lakehouse1 allows you to directly link to the CSV file in the Azure Storage account, making the data accessible within the Lakehouse without physically copying or ingesting it, thereby minimizing development effort.
A pipeline is an orchestration tool that would typically contain a Copy Data activity or Dataflow, requiring more setup and development effort compared to a shortcut for just linking to external data.
Dataflow Gen2 is used for data ingestion and transformation into a Lakehouse, which involves defining transformations and processing data, requiring more development effort than simply creating a direct link to external data.
Concept tested: Fabric Lakehouse shortcuts for external data
Source: https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-shortcuts
Topics
Community Discussion
No community discussion yet for this question.