Exam DP-600 topic 1 question 73 discussion

I think Dataflow since dataflow is like Power Query. But question is a bit unclear. Because data flow in itself is more like a whole, well, dataflow but not a singular activity like e.g. Copy Data.

Dataflow is Power Query. As we need to support M formulas from Power Query, dataflow is the answer

You can add dataflow to pipeline as activity: https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-dataflows-gen2-pipeline-activity

Although you're just copying data, which would result in a 'Copy Data' activity... you would preferably go with a Dataflow in Fabric. Especially because the big take away is that the activity must support Power Query M

Power Query M Support: Dataflows in Azure Data Factory and Synapse Analytics support the Power Query M formula language, enabling you to perform complex transformations and data manipulations as part of the data ingestion process. Transformations: Dataflows allow for a wide range of data transformation capabilities which are especially useful when working with CSV files to cleanse, aggregate, or reshape data before loading it into the destination.

A. Dataflow use powerquery. i don't think you have powerquery with copy data

The answer is Correct! To copy data from CSV files to Lakehouse1 in Workspace1, you should add a copy activity to Pipeline1. https://learn.microsoft.com/en-us/fabric/data-factory/connector-lakehouse-copy-activity

You can specify transformations using Power Query M expressions during the data copy process. This ensures that your data is transformed according to your requirements before being loaded into Lakehouse1