exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 4 question 29 discussion

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

You have a Power BI dataset and a connected report.

You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset.

You grant the users the Build permission for the dataset.

What should you do next?

  • A. Certify the dataset used by the report.
  • B. Change the default visual interaction for the report.
  • C. For the report, change the Export data setting to None.
  • D. For the report, change the Export data setting to Summarized data, data with current layout and underlying data.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
glenman0202
Highly Voted 2 years, 1 month ago
Selected Answer: C
C is the correct answer. Note the part of the question that says "ONLY by connecting directly to the dataset." As mentioned in https://www.designmind.com/blog/business-intelligence/export-underlying-data-in-power-bi, "You should export summarized data when you want to see the relevant data in the visualization." Therefore, D cannot be the right answer, as summarized data is not obtained from connecting directly to the dataset, but rather by effectively filtering the dataset based on the contents of the visualization. Additionally, the "data with current layout and underlying data" part is irrelevant - by allowing Summarized data to be exported, we allow forms of analyzing data other than connecting directly to the dataset, and thus fail the requirements of the question.
upvoted 36 times
...
jsking
Highly Voted 2 years, 3 months ago
Selected Answer: D
The correct answer is D. C is incorrect because if you change the export data setting to None, users will not be able to export the data in any form. By providing the users with Summarized data, data with current layout and underlying data option, it will not change the way data is visualized in the report, but it allows the users to download the data and analyze it with Excel.
upvoted 20 times
Aldeus
1 year, 4 months ago
That's the point, they shouldn't be able to export, just access throught excel.
upvoted 8 times
...
...
jaume
Most Recent 5 months ago
Selected Answer: C
As stated by glenman0202 the tricky par in this question is "...only by connecting directly to the dataset" therefore the report export options must be disabled
upvoted 2 times
...
asnygen
1 year, 4 months ago
chatgpt reply : Option A
upvoted 1 times
bbshu0801
1 year, 3 months ago
ChatGPT does not always give right answer.
upvoted 7 times
...
...
taod
1 year, 7 months ago
Selected Answer: C
C is correct
upvoted 2 times
...
AniveM
1 year, 10 months ago
la bonne réponse est C car la réponse D interdit aux utilisateurs d'analyser avec excel
upvoted 2 times
...
Ash_Alansari
1 year, 10 months ago
Selected Answer: C
Excel can be connected directly to an online PowerBI dataset, according to this page https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel Therefore, the only correct answer is C. D would allow an exported local copy of the data even if only summarized, which is not allowed in this scenario.
upvoted 5 times
Ash_Alansari
1 year, 10 months ago
Further information: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets
upvoted 2 times
...
...
TalktomeGoOse
1 year, 10 months ago
Selected Answer: D
D is the correct answer
upvoted 1 times
...
Nemesizz
1 year, 11 months ago
So what is the answer?
upvoted 4 times
SteveTheBeast
1 year, 8 months ago
The answer is C because in the question it is stated that users can only retrieve the data from the dataset. With answer D, you'd allow users to export data and let other users retrieve it locally which is not what we want.
upvoted 1 times
...
...
UlyUkr
1 year, 11 months ago
C is the correct answer. The word ONLY indicates that users are not allowed to export data. The answer is in the question.
upvoted 2 times
...
Shalaleh
1 year, 11 months ago
Selected Answer: C
From GPT: C. For the report, change the Export data setting to None would be the correct option. By changing the Export data setting for the report to None, you can prevent users from exporting data from the report to Excel. This ensures that users can analyze data in Excel only by connecting directly to the dataset. Option A, certifying the dataset used by the report, does not ensure that users can analyze data in Excel only by connecting directly to the dataset. Option B, changing the default visual interaction for the report, does not ensure that users can analyze data in Excel only by connecting directly to the dataset. Option D, changing the Export data setting for the report to Summarized data, data with current layout and underlying data, allows users to export data from the report to Excel, which is not what is required in this scenario.
upvoted 4 times
...
Shalaleh
1 year, 11 months ago
Selected Answer: D
The user needs to have access to report data. D is correct answer
upvoted 1 times
...
SanaCanada
1 year, 11 months ago
Selected Answer: C
Please igonore my first response After review in detail correct answer is C
upvoted 3 times
...
sa56
1 year, 12 months ago
There is no "None" Option inside export data under report setting
upvoted 1 times
...
Shalaleh
1 year, 12 months ago
Selected Answer: C
Question said "Only by connecting directly to the dataset." it means the user should not be able to EXPORT the data from report.
upvoted 2 times
...
Akhilesh_Maithani
2 years ago
C is correct i believe.
upvoted 3 times
...
SanaCanada
2 years ago
Correct Answer "D" D. For the report, change the Export data setting to Summarized data, data with current layout, and underlying data. By granting users the Build permission for the dataset, you have given them the ability to connect directly to the dataset using tools such as Microsoft Excel. To ensure that users can only analyze data in Excel by connecting directly to the dataset, you can change the Export data setting for the report to "Summarized data, data with current layout, and underlying data." This setting allows users to export data from the report to Excel, but only in a summarized format or with the current visual layout. It also allows users to view the underlying data in Excel, but not to export it as raw data. This helps to ensure that users can only access the data through the approved channel, which is the direct connection to the dataset. No confusion, No need to discuss further
upvoted 5 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago