Exam DP-600 Topic 1 Question 198 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 198
Topic #: 1
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?

Suggested Answer: A Vote an answer

The requirement is to copy data from CSV files in Azure Storage into a Fabric Lakehouse, and it must support Power Query M formula language.
Dataflow activity in Fabric pipelines allows you to use Power Query Online, which is based on the M formula language.
Notebook uses Spark (Python, PySpark, Scala, SQL), not M.
Copy data activity moves data but does not support Power Query M transformations.
Script is for T-SQL or stored procedure execution, not M.
Therefore, the correct activity is Dataflow.
Reference: Dataflows in Microsoft Fabric

by Poppy at Jun 09, 2026, 10:53 PM

Limited Time Offer

15%

Off

Get Premium DP-600 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10