exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 95 discussion

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

You have a semantic model named Model1. Model1 contains five tables that all use Import mode. Model1 contains a dynamic row-level security (RLS) role named HR. The HR role filters employee data so that HR managers only see the data of the department to which they are assigned.

You publish Model1 to a Fabric tenant and configure RLS role membership. You share the model and related reports to users.

An HR manager reports that the data they see in a report is incomplete.

What should you do to validate the data seen by the HR Manager?

  • A. Select Test as role to view the data as the HR role.
  • B. Filter the data in the report to match the intended logic of the filter for the HR department.
  • C. Select Test as role to view the report as the HR manager.
  • D. Ask the HR manager to open the report in Microsoft Power BI Desktop.
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
ab695
Highly Voted 1 year, 1 month ago
Correct answer is C., 100%. The key is in the "dynamic" row-level security. Selecting A. (HR Role only) would work for a static rule for RLS, but as it is dynamic you will need to input as well the HR manager email and make sure the rule is applied correctly.
upvoted 9 times
...
hmntkmr
Highly Voted 1 year, 3 months ago
Role name is HR not HR manager so the answer is A.
upvoted 8 times
...
73f4438
Most Recent 1 week, 3 days ago
Selected Answer: C
Option C is more tailor-fit and specific for the HR manager
upvoted 1 times
...
Babzy
1 month ago
Selected Answer: C
In Power BI Service, after publishing the model, you can test the report using a specific user account who is assigned to an RLS role.This allows you to simulate the exact view that the HR manager sees with their username and role membership applied. This helps confirm whether the RLS logic is working as expected for that specific user.
upvoted 3 times
...
mishravikas7
2 months, 2 weeks ago
Selected Answer: A
I would go with A as ther's no HR manager role provided
upvoted 1 times
...
pk07
7 months, 1 week ago
Selected Answer: A
A. Select Test as role to view the data as the HR role.
upvoted 3 times
...
AbhiShar
10 months, 2 weeks ago
Answer is A A. Select Test as role to view the data as the HR role: This option allows you to simulate the RLS settings directly. By testing the role, you can see exactly what data is being presented to users assigned to the HR role, which helps you identify if the filtering logic is correctly implemented and if there are any issues with data visibility. B. Filter the data in the report to match the intended logic of the filter for the HR department: While this might help in analyzing the report data, it does not address whether the RLS is functioning as intended. The filtering in the report might not accurately represent the RLS logic. C. Select Test as role to view the report as the HR manager: This option would allow you to see the report from the perspective of the HR manager, but it may not provide clarity on how the RLS is filtering data specifically. D. Ask the HR manager to open the report in Microsoft Power BI Desktop: This option does not directly help you validate the data as it would not give you insight into the RLS logic being applied.
upvoted 1 times
...
Pegooli
1 year ago
Selected Answer: A
The "Test as role" feature in Power BI allows you to impersonate a role to see the data as a user assigned to that role would see it. This helps in validating the RLS settings and ensuring that the data is being filtered correctly according to the RLS rules.
upvoted 2 times
...
6d1de25
1 year, 1 month ago
Selected Answer: A
A is the correct answer
upvoted 2 times
...
6d1de25
1 year, 1 month ago
Selected Answer: C
C View as report is correct
upvoted 1 times
...
tawfik21A
1 year, 1 month ago
Selected Answer: A
role name is HR
upvoted 2 times
...
b6daab0
1 year, 2 months ago
I chose A because only role and not a specific user can be tested using "Test as role".
upvoted 1 times
...
c2834e0
1 year, 2 months ago
Theres no role called HR MANAGER !!! Answer is A
upvoted 3 times
...
282b85d
1 year, 2 months ago
Selected Answer: C
Option C (Select "Test as role" to view the report as the HR manager) is the best approach as it directly validates what the specific HR manager sees under the dynamic RLS conditions, ensuring the completeness and accuracy of the data. A. Select "Test as role" to view the data as the HR role: This option is useful, but it doesn't specify viewing the report as the specific HR manager, which is crucial to identify user-specific issues.
upvoted 2 times
...
trietnv
1 year, 3 months ago
A. the question is about how to validate role of a user. https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#validate-the-roles-within-power-bi-desktop
upvoted 3 times
...
2dc6125
1 year, 3 months ago
what is the difference btw see data (A) or see report (C)?
upvoted 1 times
...
stilferx
1 year, 3 months ago
Selected Answer: C
IMHO, C) HR Manager is the winner. No HR role, because each HR assigned to the own department.
upvoted 3 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 ...