Exam DP-500 topic 1 question 83 discussion

Actual exam question from Microsoft's DP-500

Question #: 83
Topic #: 1

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 source:
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?

A. auto-binding across pipelines
B. data source rules
C. selective deployment
D. parameter rules

Show Suggested Answer

Suggested Answer: D 🗳️

by Maazi at Dec. 22, 2022, 7:15 a.m.

Comments

Submit Cancel

cherious

Highly Voted 2 years, 6 months ago

Selected Answer: D

Correct answer is D and here is why: In the best practices for deployment, there is written that you can use both data source rules and parameters as well, however, they recommend parameters. Source: https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices#use-parameters-in-your-model Also, data source rules is supported for limited data sources where I can not find Azure storage Account so I think data source won't be applicable to our case. Source: https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-get-started#supported-data-sources-for-dataflow-and-dataset-rules

upvoted 9 times

...

Maazi

Highly Voted 2 years, 6 months ago

D is the answer. This is based on what I read from https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-best-practices

upvoted 5 times

...

Fer079

Most Recent 2 years, 4 months ago

Selected Answer: D

The option D (parameter rules) in the right answer. Data source rules work for some specific sources only, below you can see the supported data sources for data set rules: https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-create-rules#supported-data-sources-for-dataflow-and-dataset-rules

upvoted 2 times

...

stfglv

2 years, 5 months ago

Step 4 from this link https://learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-get-started makes me think we should go with D.

upvoted 1 times

solref

2 years, 3 months ago

Thanks for the link :)

upvoted 1 times

...

BigEd

2 years, 6 months ago

Correct answer is B. Data Source rules are used to switch datasources when using Deployment Pipelines. Parameter Rules only work when you have created parameters within the Power BI Desktop File (.pbix)

upvoted 3 times

Maazi

2 years, 6 months ago

Having cross-check this again, I'm leaning towards B too. Will be good to see what others think too.

upvoted 2 times

...