MicrosoftMicrosoft
DP-700 · Question #3
DP-700 Question #3: Real Exam Question with Answer & Explanation
The correct answer is C: A pipeline Copy activity. To populate the Bronze layer of a lakehouse with POS1 data, a pipeline Copy activity is the most suitable method.
Design and implement data ingestion and transformation
Question
You need to recommend a method to populate the POS1 data to the lakehouse medallion layers. What should you recommend for the Bronze layer?
Options
- AA Dataflow Gen2 dataflow
- BA notebook
- CA pipeline Copy activity
- DA pipeline stored procedure
Explanation
To populate the Bronze layer of a lakehouse with POS1 data, a pipeline Copy activity is the most suitable method.
Common mistakes.
- A. A Dataflow Gen2 dataflow is primarily used for data transformation and cleansing, which is more aligned with the Silver or Gold layers of a medallion architecture, not the raw ingestion phase of the Bronze layer.
- B. A notebook, typically utilizing Apache Spark, is suitable for complex data transformations, processing, and analysis, which is an overkill for the simple raw data ingestion required for a Bronze layer.
- D. A pipeline stored procedure activity executes SQL stored procedures, which is not a native or efficient mechanism for ingesting raw data from external systems into a lakehouse.
Concept tested. Data Ingestion for Lakehouse Bronze Layer
Reference. https://learn.microsoft.com/en-us/fabric/data-factory/copy-data-activity
Topics
#Lakehouse architecture#Medallion architecture#Data ingestion#Data Pipelines
Community Discussion
No community discussion yet for this question.