nerdexam
Microsoft

DP-500 · Question #13

You have a Power BI workspace that contains one dataset and four reports that connect to the dataset. The dataset uses Import storage mode and contains the following data sources: A CSV file in an…

The correct answer is A. parameter rules. To manage different data source locations across deployment pipeline stages for a dataset using Import storage mode, you should configure parameter rules.

Implement and manage a data analytics environment

Question

You have a Power BI workspace that contains one dataset and four reports that connect to the dataset. The dataset uses Import storage mode and contains the following data sources:
  • A CSV file in an Azure Storage account
  • An Azure Database for PostgreSQL database
You plan to use deployment pipelines to promote the content from development to test to production. There will be different data source locations for each stage. What should you include in the deployment pipeline to ensure that the appropriate data source locations are used during each stage?

Options

  • Aparameter rules
  • Bselective deployment
  • Cauto-binding across pipelines
  • Ddata source rules

How the community answered

(40 responses)
  • A
    75% (30)
  • B
    15% (6)
  • C
    8% (3)
  • D
    3% (1)

Why each option

To manage different data source locations across deployment pipeline stages for a dataset using Import storage mode, you should configure parameter rules.

Aparameter rulesCorrect

Parameter rules allow you to dynamically change connection string parameters (like server names, database names, or file paths) for imported datasets in each deployment pipeline stage, ensuring that the content connects to the correct data sources in development, test, and production environments.

Bselective deployment

Selective deployment allows you to choose which specific items (reports, datasets, dashboards) to deploy, but it does not address the configuration of different data source locations.

Cauto-binding across pipelines

Auto-binding across pipelines refers to automatically connecting deployed reports to existing datasets in the target workspace, not configuring data source connection details.

Ddata source rules

Data source rules are typically used for DirectQuery and Live Connection scenarios to override connection strings, whereas parameter rules are designed for managing data source paths or server names for datasets in Import mode.

Concept tested: Power BI deployment pipeline parameter rules for Import datasets

Source: https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-rules#parameter-rules

Topics

#Deployment Pipelines#Power BI Service#Data Source Management#Parameter Rules

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice