ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 4 question 6 discussion

Actual exam question from Microsoft's PL-300
Question #: 6
Topic #: 4
[All PL-300 Questions]

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 Hide Answer
Suggested Answer: D 🗳️
by fred92 at Oct. 24, 2022, 2:02 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
fred92
Highly Voted 2 years, 6 months ago
Selected Answer: D
Answer is correct
upvoted 22 times
...
jaume
Most Recent 5 months, 1 week 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
8 months ago
Selected Answer: D
Modify the data source settings
upvoted 2 times
...
Dani_eL
1 year, 1 month ago
Selected Answer: D
File > options and settings > data source settings
upvoted 3 times
...
28485e1
1 year, 1 month ago
This was on my exam 2/2024.
upvoted 4 times
...
MEG_Florida
1 year, 9 months ago
Selected Answer: D
D is correct
upvoted 3 times
...
Shalaleh
2 years ago
Selected Answer: D
Given answer is correct.
upvoted 4 times
...
pepix74
2 years, 1 month ago
Selected Answer: D
D is correct
upvoted 3 times
...
Michcat
2 years, 1 month 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 ago
The same data, will migrate to another source. That means the schema is identical.
upvoted 2 times
...
...
yordiye
2 years, 3 months ago
D is correct
upvoted 1 times
...
csillag
2 years, 4 months ago
Selected Answer: D
is Correct
upvoted 1 times
...
Hoeishetmogelijk
2 years, 4 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, 5 months ago
Selected Answer: D
D is correct
upvoted 2 times
...
Mazhar332
2 years, 6 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, 4 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, 6 months ago
D. Modify the Data source settings. is correct.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago