nerdexam
Microsoft

DP-600 · Question #112

You have a Fabric workspace that contains a Microsoft Power BI report named Report1. Your organization does not currently have an enterprise data warehouse. You need to leverage dataflows to bring…

The correct answer is C. Create a staging dataflow that will only copy the data from the source as-is. To handle a data source with restricted access windows when ingesting data via dataflows, a staging dataflow should be created to copy data as-is during the available window.

Submitted by dimitri_ru· Apr 18, 2026Prepare and serve data

Question

You have a Fabric workspace that contains a Microsoft Power BI report named Report1. Your organization does not currently have an enterprise data warehouse. You need to leverage dataflows to bring data into a Power BI semantic model. You notice that access to one of the data sources is restricted to narrow time windows. What should you do?

Options

  • ACreate a linked table that will reference the data from another dataflow.
  • BCreate a shared dataset that can be reused by multiple Power BI reports.
  • CCreate a staging dataflow that will only copy the data from the source as-is.
  • DCreate a transformation dataflow that will apply all the necessary data transformations.

How the community answered

(14 responses)
  • A
    7% (1)
  • B
    14% (2)
  • C
    79% (11)

Why each option

To handle a data source with restricted access windows when ingesting data via dataflows, a staging dataflow should be created to copy data as-is during the available window.

ACreate a linked table that will reference the data from another dataflow.

Creating a linked table within another dataflow assumes the data is already in another dataflow, but the immediate problem is extracting data from the *source* under time constraints.

BCreate a shared dataset that can be reused by multiple Power BI reports.

Creating a shared dataset is for reusing processed data in Power BI reports, not for solving the problem of restricted source data access during ingestion.

CCreate a staging dataflow that will only copy the data from the source as-is.Correct

A staging dataflow is designed to extract raw data from the source with minimal or no transformations. This approach allows the data to be pulled during the narrow access window and then stored, making it available for subsequent transformation dataflows to process without requiring direct access to the restricted source again.

DCreate a transformation dataflow that will apply all the necessary data transformations.

Applying all necessary transformations directly in a single dataflow would extend the processing time within the narrow access window, potentially causing the extraction to fail or be incomplete.

Concept tested: Dataflow staging for restricted sources

Source: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-best-practices-reuse#how-to-create-staging-dataflows

Topics

#Dataflows#Staging Data#Data Ingestion#Data Pipeline Design

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-600 Practice