What is the recommended approach to ingest data into the bronze layer of the Lakehouse Medallion Architecture to minimize implementation effort?

• A. Notebook
• B. Dataflow Gen2
• C. Stored Procedure Activity
• D. Copy Data Activity

Answer: (D)

Ingesting data into the bronze layer with minimal effort is achieved by using a simple data copy mechanism that lands data as-is. Copy Data Activity is built for moving data from many sources into storage with little to no transformation, which aligns with bronze’s role of storing raw data. It supports a wide range of connectors, can ingest files or tables, and preserves the source data in its native form. It also handles parallelism and fault tolerance, and can be configured for full or incremental loads without writing custom code. Other options require more development work or involve transformations, which increases effort. So, Copy Data Activity best minimizes implementation effort while reliably loading data into the bronze layer.