nerdexam
Microsoft

DP-700 · Question #6

When the authors have new book releases, there is often an increase in sales activity. This increase slows the data ingestion process. The company's sales team reports that during the last month…

The correct answer is E. Configure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month. To resolve slow data ingestion, ensure up-to-date data, and minimize data transferred, configure incremental refresh for the dataflow and set the refresh window to 1 Month.

Design and implement data ingestion and transformation

Question

When the authors have new book releases, there is often an increase in sales activity. This increase slows the data ingestion process. The company's sales team reports that during the last month, the sales data has NOT been up-to-date when they arrive at work in the morning. You need to resolve the sales data issue. The solution must Minimize the amount of data transferred. What should you do?

Options

  • ASplit the dataflow into two dataflows.
  • BConfigure scheduled refresh for the dataflow.
  • CConfigure incremental refresh for the dataflow. Set Store rows from the past to 1 Month.
  • DConfigure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Year.
  • EConfigure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month.

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    13% (4)
  • C
    7% (2)
  • E
    77% (23)

Why each option

To resolve slow data ingestion, ensure up-to-date data, and minimize data transferred, configure incremental refresh for the dataflow and set the refresh window to 1 Month.

ASplit the dataflow into two dataflows.

Splitting a dataflow might help with parallelism, but it does not inherently minimize the total volume of data transferred during the ingestion process.

BConfigure scheduled refresh for the dataflow.

Configuring a scheduled refresh ensures regularity but does not minimize data transfer if it performs a full refresh each time, potentially exacerbating performance issues for large datasets.

CConfigure incremental refresh for the dataflow. Set Store rows from the past to 1 Month.

'Store rows from the past' defines the historical data retention policy for the dataflow, not the window for which data is refreshed incrementally, thus it doesn't directly address minimizing data transfer during refresh operations.

DConfigure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Year.

Setting 'Refresh rows from the past' to 1 Year would process a much larger dataset than necessary for daily updates, leading to increased data transfer and longer refresh times, which contradicts the requirement to minimize data transferred.

EConfigure incremental refresh for the dataflow. Set Refresh rows from the past to 1 Month.Correct

Configuring incremental refresh is the most effective solution to minimize the amount of data transferred and improve refresh times, especially for frequently updated datasets. Setting 'Refresh rows from the past' to 1 Month ensures that only recent, relevant data is processed, making the data up-to-date daily while avoiding re-processing of unchanged historical data.

Concept tested: Dataflow Incremental Refresh Configuration

Source: https://learn.microsoft.com/en-us/power-query/dataflows/incremental-refresh

Topics

#Incremental Refresh#Data Ingestion Optimization#Dataflow#Performance Optimization

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice