Forum Discussion
Helper IIAdd data to lakehouse from Azure storage
Hi-
I am preparing an exam, but I am always confused with the question. Here it says "add", does it mean to physically import or ingest data? Or just access and reference?
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?
A. copy job
B. shortcut
C. pipeline
D. Dataflow Gen2
Hi New_worker
Thank you for reaching out microsoft fabric community forum.
yes ,you are right . Copy job is correct.copy job physically ingests the data into Lakehouse1 from an external source like Azure Storage. It's the simplest way to add data with minimal development effort.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.
6 Replies
Hi New_worker
Thank you for reaching out microsoft fabric community forum.
yes ,you are right . Copy job is correct.copy job physically ingests the data into Lakehouse1 from an external source like Azure Storage. It's the simplest way to add data with minimal development effort.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.- Deku
Super User
It means ingest in this case. Shortcutting only works within onelake, but in that question the data source is outside of fabric.
New_workerThanks Deku for your reply.
I dont think shortcut only works within onelake. But if it means ingest data, then the answer should be A. copy job.
Hi New_worker
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
rohit1991Hi New_worker ,
In this case, the term "add data to Lakehouse1" from a CSV file stored in Azure Storage (outside Fabric) clearly implies that the data needs to be physically ingested not just referenced. Since the source is external, a shortcut won’t work here. Shortcuts only reference data already within OneLake, and that’s not the case in this scenario.
So the correct answer is A. Copy job.
A copy job moves the data into OneLake behind the scenes and makes it part of the Lakehouse. It’s simple, low-effort, and doesn’t require setting up full pipelines exactly what the question is aiming for when it says “minimal development effort.”Hi New_worker
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
