Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 80

You are optimizing a dataflow in a Power BI Premium capacity. The dataflow performs multiple joins.
You need to reduce the load time of the dataflow.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Answer options

• A. Execute foldable operations before non-foldable operations.
• B. Place the ingestion operations and transformation operations in a single dataflow.
• C. Execute non-foldable operations before foldable operations.
• D. Place the ingestion operations and transformation operations in separate dataflows.
• E. Reduce the memory assigned to the dataflows.

Correct answer: A, D

Explanation

Executing foldable operations before non-foldable operations helps leverage query folding to optimize performance, which is why option A is correct. Option D is also correct because separating ingestion and transformation can lead to better performance management. Options B and C do not prioritize performance optimally, and option E is counterproductive, as reducing memory can lead to slower processing.