Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 4 question 6 discussion

Actual exam question from Microsoft's PL-300

Question #: 6
Topic #: 4

You have a PBIX file that imports several tables from an Azure SQL database.
The data will be migrated to another Azure SQL database.
You need to change the connections in the PBIX file. The solution must minimize administrative effort.
What should you do?

A. From Power Query Editor, create new queries.
B. From Power Query Editor, modify the source of each query.
C. Create a PBIT file, open the file, and change the data sources when prompted.
D. Modify the Data source settings.

Show Suggested Answer

Suggested Answer: D 🗳️

by fred92 at Oct. 24, 2022, 2:02 p.m.

Comments

Submit Cancel

fred92

Highly Voted 2 years, 9 months ago

Selected Answer: D

Answer is correct

upvoted 22 times

...

jaume

Most Recent 8 months, 3 weeks ago

Selected Answer: D

I think option B would also work but would be not the one minimizing administrative effort. Option C should be the right solution here.

upvoted 1 times

...

nammm112

11 months, 1 week ago

Selected Answer: D

Modify the data source settings

upvoted 2 times

...

Dani_eL

1 year, 5 months ago

Selected Answer: D

File > options and settings > data source settings

upvoted 3 times

...

28485e1

1 year, 5 months ago

This was on my exam 2/2024.

upvoted 4 times

...

Acrious

2 years ago

Selected Answer: D

D is correct

upvoted 3 times

...

Shalaleh

2 years, 3 months ago

Selected Answer: D

Given answer is correct.

upvoted 4 times

...

pepix74

2 years, 4 months ago

Selected Answer: D

D is correct

upvoted 3 times

...

Michcat

2 years, 5 months ago

The assumed answer is D, but practically, it needs the schema of both sources to be identical. Otherwise, it may prompt fatal errors with caches swapped.

upvoted 2 times

Shalaleh

2 years, 3 months ago

The same data, will migrate to another source. That means the schema is identical.

upvoted 2 times

...

yordiye

2 years, 7 months ago

D is correct

upvoted 1 times

...

csillag

2 years, 7 months ago

Selected Answer: D

is Correct

upvoted 1 times

...

Hoeishetmogelijk

2 years, 8 months ago

Selected Answer: D

B could work, but D takes the least effort. So the answer is D. (Assuming that the table names and definitions remain the same)

upvoted 3 times

...

lukelin08

2 years, 8 months ago

Selected Answer: D

D is correct

upvoted 2 times

...

Mazhar332

2 years, 9 months ago

Selected Answer: C

I guess C is the correct answer. Since you need to minimize administrative effort of user.

upvoted 1 times

Hoeishetmogelijk

2 years, 8 months ago

I'm sorry, but C is not correct: "A PBIT file acts as a Power BI template. It doesn’t include any data from your source systems. So, if you’re mashing up data from Excel files with some data from SQL Server and load that data into your Power BI model, when you save that file as PBIT it clears all of your data, but keeps your report structure." Source: https://www.datavizioner.com/resources/pbit-vs-pbix-how-and-why-theyre-different/#:~:text=A%20PBIT%20file%20acts%20as,but%20keeps%20your%20report%20structure.

upvoted 2 times

...

Booster21

2 years, 9 months ago

D. Modify the Data source settings. is correct.

upvoted 4 times

...