Which statement correctly describes the use of Power Query Online with Dataflow Gen2?

Prepare for the DP-700 Microsoft Fabric Data Engineer Exam with flashcards and multiple choice questions. Study with hints and explanations, and ensure success on your certification exam!

Multiple Choice

Which statement correctly describes the use of Power Query Online with Dataflow Gen2?

Explanation:
Power Query Online acts as the transformation engine inside Dataflow Gen2. It handles the ETL work—defining queries to shape, filter, merge, and compute columns, which run as part of the dataflow’s load or refresh process. This shows why it’s the transformation engine: the role is to transform data, not merely to read it or export it elsewhere. The other statements don’t fit because the engine is indeed used for transformations in Gen2, and Excel export isn’t a built-in function of the dataflow’s transformation process.

Power Query Online acts as the transformation engine inside Dataflow Gen2. It handles the ETL work—defining queries to shape, filter, merge, and compute columns, which run as part of the dataflow’s load or refresh process. This shows why it’s the transformation engine: the role is to transform data, not merely to read it or export it elsewhere. The other statements don’t fit because the engine is indeed used for transformations in Gen2, and Excel export isn’t a built-in function of the dataflow’s transformation process.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy