exam questions

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam

Exam DP-500 topic 1 question 88 discussion

Actual exam question from Microsoft's DP-500
Question #: 88
Topic #: 1
[All DP-500 Questions]

You have new security and governance protocols for Power BI reports and datasets. The new protocols must meet the following requirements:
New reports can be embedded only in locations that require authentication.
Live connections are permitted only for workspaces that use Premium capacity datasets.
Which three actions should you recommend performing in the Power BI Admin portal? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. From Embed Codes, delete all the codes.
  • B. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
  • C. From Capacity settings, set XMLA Endpoint to Read Write.
  • D. From the Premium per user settings, set XMLA Endpoint to Off.
  • E. From Tenant settings, set Publish to web to Disable.
Show Suggested Answer Hide Answer
Suggested Answer: ADE 🗳️

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
jesnor
Highly Voted 2 years, 6 months ago
Only A, D, E makes sense
upvoted 7 times
...
cherious
Highly Voted 2 years, 5 months ago
Selected Answer: ADE
I changed m answer. B would not be correct because if you disable XMLA then you won't be able to embed the reports in the locations that require authentication. Plus, when the user uses Analyze service feature he/she goes authorization
upvoted 6 times
...
ExamPage
Most Recent 1 year, 10 months ago
Selected Answer: ABE
The correct answers are A, B, and E. A. From Embed Codes, delete all the codes. This will prevent users from embedding reports in locations that do not require authentication. B. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets. This will prevent users from connecting to datasets using XMLA endpoints, which is a way to programmatically access data in Power BI. E. From Tenant settings, set Publish to web to Disable. This will prevent users from publishing reports to the web, which is a way to make reports accessible to anyone with an internet connection.
upvoted 4 times
ExamPage
1 year, 10 months ago
The other options are incorrect. C. From Capacity settings, set XMLA Endpoint to Read Write. This is not necessary, as the Allow XMLA endpoints setting in Tenant settings will control whether or not XMLA endpoints are enabled for all capacities. D. From the Premium per user settings, set XMLA Endpoint to Off. This is not necessary, as the Allow XMLA endpoints setting in Tenant settings will control whether or not XMLA endpoints are enabled for all capacities, including Premium per user capacities.
upvoted 1 times
...
...
ajaysharma2061
2 years, 3 months ago
Correct Answers: B, D , E Based on the requirements, the following three actions should be recommended in the Power BI Admin portal: B. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets. This will restrict the use of XMLA endpoints and prevent users from analyzing on-premises datasets in Excel. D. From the Premium per user settings, set XMLA Endpoint to Off. This will ensure that users with Premium per user licenses cannot use XMLA endpoints. E. From Tenant settings, set Publish to web to Disable. This will prevent reports and dashboards from being shared publicly using Publish to web, ensuring that they are only embedded in locations that require authentication. Therefore, the correct answers are B (disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets), D (set XMLA Endpoint to Off for Premium per user settings), and E (set Publish to web to Disable in Tenant settings).
upvoted 4 times
...
Az301301X
2 years, 3 months ago
Selected Answer: BCE
The requirements state that new reports can only be embedded in authenticated locations and live connections should only be allowed for workspaces with Premium capacity datasets. To meet these requirements, the following actions should be recommended in the Power BI Admin portal: B. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets: This will disable the ability to use XMLA endpoints and analyze on-premises datasets, which helps to ensure that data is only accessible through authenticated channels. C. From Capacity settings, set XMLA Endpoint to Read Write: This will allow read and write access to the XMLA endpoint for Premium capacity workspaces, which can help to ensure that data is only accessible through authenticated channels. E. From Tenant settings, set Publish to web to Disable: This will disable the ability to publish reports to the web, which can help to ensure that data is only accessible through authenticated channels.
upvoted 1 times
Az301301X
2 years, 3 months ago
Therefore, the recommended actions are: B. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets. C. From Capacity settings, set XMLA Endpoint to Read Write. E. From Tenant settings, set Publish to web to Disable.
upvoted 1 times
Az301301X
2 years, 3 months ago
BTW: These answers were given by Chat GPT
upvoted 1 times
...
...
ajaysharma2061
2 years, 3 months ago
Please ask ChatGPT Again that are you sure and this will change the answer. You can try two three times, till you get the right answer ;)
upvoted 1 times
...
...
Fer079
2 years, 4 months ago
Selected Answer: CDE
C,D,E C - I think that the XMLA Endopoint property must be enabled read-write by the capacity admin (by default this is set to read only): https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#security Also, you can see here that "Allow XMLA endpoints and Analyze in Excel with on-premises datasets" option should be enabled, so the option B is not correct. D - As the question says "Live connections are permitted only for workspaces that use Premium capacity datasets" then we should disable the XMLA Endpoint for Premium per user settings E - Set Publish to web to disable will avoid to publish to public webs, also when this option is disabled then all the existing Embed Codes are disabled too, so it's not necessary to delete them (Option A would be optional in this case) https://learn.microsoft.com/en-us/power-bi/admin/service-admin-portal-embed-codes#disable-embed-codes
upvoted 1 times
...
Ngol
2 years, 5 months ago
Selected Answer: ADE
ADE is correct
upvoted 4 times
...
cherious
2 years, 6 months ago
Selected Answer: BDE
BC can't be both happen simultaneously: "In addition to the XMLA Endpoint property being enabled read-write by the capacity admin, the tenant-level setting Allow XMLA endpoints and Analyze in Excel with on-premises datasets must be enabled in the admin portal." Source: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#security
upvoted 3 times
...
AshwinN1992
2 years, 6 months ago
Please confirm the options
upvoted 1 times
stfglv
2 years, 5 months ago
ADE is the correct answer for sure
upvoted 2 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 ...