exam questions

Exam PL-200 All Questions

View all questions & answers for the PL-200 exam

Exam PL-200 topic 5 question 16 discussion

Actual exam question from Microsoft's PL-200
Question #: 16
Topic #: 5
[All PL-200 Questions]

You create a report by using Power BI Desktop and a Power BI dataset that is connected to Azure SQL Database.
Multiple groups of employees will use the report.
You need to ensure that each group of employees can see only data that pertains to their group.
What should you do?

  • A. Create and assign field security profiles.
  • B. Create and assign Common Data Service security roles.
  • C. Create and assign roles by using row-level security.
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
gk_1989
Highly Voted 4 years, 3 months ago
Correct. When you share a dashboard with colleagues you are sharing the underlying dataset as well. Your colleagues get access to the entire dataset unless row-level security (RLS) limits their access. Report authors may use capabilities that customize user experiences when viewing or interacting with reports, for example hiding columns, limiting the actions on visuals, and others. These customized user experience do not restrict what data users can access in the dataset. Use row-level security (RLS) in the dataset so that each person's credentials determine which data they can access.
upvoted 42 times
HassanSarhan
3 years, 11 months ago
correct, thank you
upvoted 3 times
...
...
avow
Highly Voted 4 years, 2 months ago
Row is the new terminology being used for field. So this is field level security, which would be the right answer.
upvoted 6 times
ZVV
4 years, 1 month ago
don't confuse peoples...
upvoted 25 times
...
Cyriharsh
3 years, 10 months ago
Not correct. row = record, and the new name for Field is Column. So RLS is not related to field security at all.
upvoted 14 times
HARRISONP04
2 years, 3 months ago
wrong, field is a record, rows and columns haven't changed terminology
upvoted 1 times
RafsanH
1 year, 8 months ago
Rows in a traditional database are equivalent to Records in Dataverse. Columns in a traditional database are equivalent to Fields in Dataverse.
upvoted 1 times
...
...
...
...
33a7f9e
Most Recent 7 months ago
To ensure that each group of employees can see only the data that pertains to their group, you should: C. Create and assign roles by using row-level security (RLS). Row-level security allows you to restrict data access for users based on filters you define within roles. You can create roles and apply filters that ensure each group of employees only sees the data relevant to them1
upvoted 1 times
...
JohnChung
1 year, 2 months ago
Selected Answer: C
I am sure the correct answer is C. Scored 958/1000 in PL-300 exam
upvoted 2 times
...
Agnes202307
1 year, 3 months ago
Selected Answer: C
Correct.
upvoted 1 times
...
DSM_LM
1 year, 5 months ago
Selected Answer: C
Correct
upvoted 1 times
...
Ikhalil
2 years, 1 month ago
is C correct
upvoted 1 times
...
MS_KoolaidMan
2 years, 2 months ago
Selected Answer: C
C is correct.
upvoted 1 times
...
jkaur
3 years, 2 months ago
Correct
upvoted 2 times
...
SarAbd
3 years, 7 months ago
In exam 16/09/2021
upvoted 1 times
...
ShreyaU
3 years, 9 months ago
In exam on 21 July 2021.
upvoted 2 times
...
mel28
4 years, 2 months ago
RLS https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago