Fabric Analytics Engineer Associate Full Exam Prep 2026

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards

From $12.50Unlock all

Session length

1 / 20

Why can performing a split by position on a column cause a dataflow to load more data than expected?

It converts DateTime to string

It increases network latency

It enables dynamic query optimization

It causes the data to be pulled into Power Query before filtering

Split by position can’t be folded back to the data source. In Power Query/Dataflows, query folding pushes as many operations as possible down to the source so only the needed rows are retrieved. When you split by position, the transformation isn’t something the source can apply, so the data must be pulled into Power Query first, then the split is performed and the filters are applied afterwards. That means more data is loaded into the flow than if the filtering could have happened at the source.

So the reason this causes more data to be loaded is that the data is pulled into Power Query before filtering, rather than filtering at the source.