Implementing Analytics Solutions Using Microsoft Fabric — Question 96

You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1.

In Workspace1, you create a data pipeline named Pipeline1.

You have CSV files stored in an Azure Storage account.

You need to add an activity to Pipeline1 that will copy data from the CSV files to Lakehouse1. The activity must support Power Query M formula language expressions.

Which type of activity should you add?

Answer options

• A. Dataflow
• B. Notebook
• C. Script
• D. Copy data

Correct answer: A

Explanation

The correct answer is A, Dataflow, as it allows for the use of Power Query M formula language expressions, which is a requirement in this scenario. The other options, such as Notebook, Script, and Copy data, do not provide the necessary support for Power Query M expressions, making them unsuitable for this task.