Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 1 question 9 discussion

Actual exam question from Microsoft's DA-100

Question #: 9
Topic #: 1

You have the following three versions of an Azure SQL database:
✑ Test
✑ Production
✑ Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?

A. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
B. Create a parameter and update the queries to use the parameter.
C. Create a query for each database server and hide the development tables.
D. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Show Suggested Answer

Suggested Answer: B 🗳️

by NS1992 at May 19, 2022, 9:38 a.m.

Comments

Submit Cancel

NS1992

Highly Voted 3 years ago

Create a parameter and update the queries to use the parameter.

upvoted 29 times

...

LGWANGWADZA

Highly Voted 3 years ago

B. Create a parameter and update the queries to use the parameter. Thats the correct answerit allows you to change the data source by just changing the parameter

upvoted 10 times

...

Ahmadbaww

Most Recent 1 year, 11 months ago

Selected Answer: B

B is the fastest way

upvoted 1 times

...

rash_12

2 years, 5 months ago

Create a parameter and update the queries to use the parameter.

upvoted 1 times

...

RichardOgoma

2 years, 8 months ago

Selected Answer: B

Using parameters is a very important concept for deployment pipelines and working across the deployment workspaces

upvoted 2 times

...

halfway

2 years, 9 months ago

Selected Answer: B

https://www.phdata.io/blog/how-to-parameterize-data-sources-power-bi/

upvoted 2 times

...

Abhilash19

2 years, 9 months ago

Option B - In dataset setting we can change the environment using parameters.

upvoted 1 times

...

RamzanAnjum

2 years, 10 months ago

Data privacy (Privacy levels) is used to protect data rather than data souce. So, I think it is parameter - Option B

upvoted 1 times

...

Mazarakis

2 years, 11 months ago

Correct Answer is Β. when you upload the report , you go to uploaded dataset--> ... --> settings --> Parameters.

upvoted 1 times

...

Ishan1510

2 years, 11 months ago

but parameters don't work on Power bi service

upvoted 2 times

BitwiseLS

2 years, 11 months ago

Once you added parameters and added them to the query, you can change them in the settings of the dataset.

upvoted 2 times

...

Soksay

2 years, 12 months ago

Selected Answer: B

I would say B

upvoted 1 times

...

YeDA

3 years ago

The correct answer is "Create a Parameter...." There is another option but it is not on the list. The best option is by creating a deployment pipeline in Power BI Serices.

upvoted 2 times