BenchMark Quizzes by MDFT Pro

Determine Query Folding in Fabric Dataflow

You work for MDFT Pro, a well-known training agency. You have a Fabric tenant that contains two lakehouses, and you are building a dataflow that will combine data from the lakehouses.

The query settings from one of the queries in the dataflow are as follows:

Name: Students
Entity type: Custom
Applied steps:
  1. Source
  2. Navigation 1
  3. Capitalize each word
  4. Appended query
  5. Changed column type
  6. Added custom
  7. Filtered rows

Please complete the following statement:

________ of the transformation steps in the query will fold.

Choose the correct answer from the options below.

Explanations for each answer:

All is incorrect. Not all transformation steps in this query can be folded. Specifically, the 'Capitalize each word' and 'Added custom' cannot be folded. 'Appended query' and 'Fitered rows' might fold, if the query mashup engine can execute them before 'Capitalize each word'.
Some is correct. Some transformation steps can be folded back to the source. Steps 1-2 (Source, Navigation 1) can fold. However, step 3 (Capitalize each word) breaks folding because it's a text transformation not supported by the source. All subsequent steps (4-7) cannot fold because they follow the breaking step.
None is incorrect. Some transformation steps in this query can be folded. Specifically, 'Source' and 'Navigation 1' can be folded. 'Appended query' and 'Fitered rows' might fold, if the query mashup engine can execute them before 'Capitalize each word'.

Learn more about query folding in Fabric dataflows:

Query Folding in Fabric

Practice Exam

Determine Query Folding in Fabric Dataflow

Discuss this question on social media: