Exam PL-200 topic 5 question 16 discussion

Actual exam question from Microsoft's PL-200

Question #: 16
Topic #: 5

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

Suggested Answer: C 🗳️

by gk_1989 at Jan. 23, 2021, 1:35 p.m.

Comments

Submit Cancel

gk_1989

Highly Voted 4 years, 6 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

4 years, 2 months ago

correct, thank you

upvoted 3 times

...

avow

Highly Voted 4 years, 5 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, 4 months ago

don't confuse peoples...

upvoted 25 times

...

Cyriharsh

4 years, 1 month 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, 6 months ago

wrong, field is a record, rows and columns haven't changed terminology

upvoted 1 times

RafsanH

1 year, 11 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 10 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

...