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
[Removed]
Highly Voted 1 year ago
Selected Answer: C
Although A basically is true as well, C would be "the most" correct. For instance, if the HR manager is not part of the HR role, doing as described in A would not help you troubleshoot the issue. Also, if the RLS is set up such that different HR managers have different rows visible, you have to select the person. Thus, C is more correct than A.
upvoted 16 times
...
hmntkmr
Highly Voted 1 year ago
Role name is HR not HR manager so the answer is A.
upvoted 8 times
...
pk07
Most Recent 4 months, 1 week ago
Selected Answer: A
A. Select Test as role to view the data as the HR role.
upvoted 2 times
...
AbhiShar
7 months, 1 week 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
9 months, 3 weeks 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
10 months, 1 week ago
Selected Answer: A
A is the correct answer
upvoted 2 times
...
ab695
10 months, 1 week 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 5 times
...
6d1de25
10 months, 1 week ago
Selected Answer: C
C View as report is correct
upvoted 1 times
...
tawfik21A
11 months ago
Selected Answer: A
role name is HR
upvoted 2 times
...
b6daab0
11 months ago
I chose A because only role and not a specific user can be tested using "Test as role".
upvoted 1 times
...
c2834e0
11 months ago
Theres no role called HR MANAGER !!! Answer is A
upvoted 3 times
...
282b85d
11 months, 3 weeks 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 1 times
...
trietnv
1 year 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 ago
what is the difference btw see data (A) or see report (C)?
upvoted 1 times
...
stilferx
1 year ago
Selected Answer: C
IMHO, C) HR Manager is the winner. No HR role, because each HR assigned to the own department.
upvoted 2 times
...
e0f0ce6
1 year ago
You have to check the problem of a particular user. So we should select "C". Maybe the user isn't part of the role. So "A" would achieve nothing.
upvoted 1 times
...
Unbounded
1 year ago
Selected Answer: B
A & C: says "Test" as role. We do not know what conditions we have in Test. To test these conditions we should select B
upvoted 1 times
AdventureChick
5 months ago
The functionality is called "Test as Role". It's an option that allows you to view reports as if you were a different user. It's used to validate/troubleshoot security and you can "Test as Role" on both roles and specific users. They aren't talking about a test environment.
upvoted 1 times
...
2dc6125
1 year ago
That's what i was thinking and my way to test and do comparison, but haven't done that in fabric so interesting in why would we choose A or C instead
upvoted 1 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