nerdexam
Microsoft

DP-500 · Question #59

Based on a query dependency diagram, which action will reduce data refresh times for this model?

The correct answer is B. Replacing the Orders query with a dataflow. Replacing a query with a dataflow can significantly reduce data refresh times by allowing the dataflow to pre-process and store data in Azure Data Lake Storage Gen2, which Power BI can then consume more efficiently.

Implement and manage a data analytics environment

Question

Based on a query dependency diagram, which action will reduce data refresh times for this model?

Options

  • ADuplicating the Orders query instead of referencing the query
  • BReplacing the Orders query with a dataflow
  • CUsing Table Buffer in the Orders query

How the community answered

(35 responses)
  • A
    11% (4)
  • B
    83% (29)
  • C
    6% (2)

Why each option

Replacing a query with a dataflow can significantly reduce data refresh times by allowing the dataflow to pre-process and store data in Azure Data Lake Storage Gen2, which Power BI can then consume more efficiently.

ADuplicating the Orders query instead of referencing the query

Duplicating the Orders query instead of referencing it would likely increase refresh times, as the query logic would be executed multiple times, once for each duplicate, rather than once for a single referenced query.

BReplacing the Orders query with a dataflowCorrect

Replacing a query with a dataflow allows for data transformation and storage outside of the Power BI dataset refresh process. Dataflows can be refreshed independently, and the transformed data stored in Azure Data Lake Storage Gen2 can be consumed by the Power BI model, significantly reducing the refresh burden on the report itself and improving refresh times.

CUsing Table Buffer in the Orders query

While Table.Buffer can sometimes improve performance by caching intermediate table results, its impact is often localized and may not provide a significant model-wide refresh time reduction compared to the architectural benefit of dataflows, and it can increase memory consumption.

Concept tested: Power BI dataflow benefits for refresh optimization

Source: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction

Topics

#Dataflows#Refresh optimization#Power BI performance#Data preparation

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice