Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 68 discussion

Actual exam question from Microsoft's PL-300

Question #: 68
Topic #: 2

DRAG DROP
-

You have the Power BI data model shown in the following exhibit.

The Country table contains the following data.

You create two row-level security (RLS) roles named Manager and CFO.

You plan to publish the dataset to the Power BI service.

You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.
• The CFO must be prevented from seeing the data in the Human Resources table.
• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Erick94 at April 1, 2023, 3:11 a.m.

Comments

Submit Cancel

semauni

Highly Voted 2 years, 1 month ago

I simply don't get the answers to the question, or the question at all for that matter. I feel both should have two conditions... Like: HR = AND([Manager] <> "CFO", [Email] = userprinciplename()) Country = OR([MANAGER = "CFO", [Email] = userprinciplename()) What am I missing here?

upvoted 89 times

kvs_analyst

3 months, 1 week ago

The question seems unclear or incomplete. It asks for DAX filters for two roles, CFO and Manager, but provides only two blanks (HR and Country) without specifying the role. If the filters are for the CFO role: - HR: False() to restrict access to HR data. - Country: [Email] = USERPRINCIPALNAME() to allow access based on email. If the filters are for the Manager role: - HR: leave blank to allow HR data access. - Country: [Email] = USERPRINCIPALNAME() to restrict data to their country. It seems the question is more aligned with the CFO role.

upvoted 1 times

...

660091f

1 year, 2 months ago

I thought, I was the only one

upvoted 4 times

...

saraplez

Highly Voted 2 years ago

Human Resources > False () Country > [Email] = USERPRINCIPALNAME () Explanation: I would create 2 RLS: 1st with Human Resources > False () Add CFO user • The CFO must be prevented from seeing the data in the Human Resources table. • The CFO must see the sales data of all countries. 2nd with Country > [Email] = USERPRINCIPALNAME () Add manger users: •Each manager must see only the data in the Sales and Human Resources tables for their own country.

upvoted 71 times

SilentAnalyst

1 year, 3 months ago

To build on top of saraplez answer, note that we are defining two roles: Manager and CFO For the role CFO we create the following filter on the Human Resources table: false() Anyone assigned to this CFO role, will not have access to the Human Resources data. We only add the first manager (CFO) to this role. for the role Manager, we create the following filter on the Country table: [Email] = USERPRINCIPALNAME () We add Philipe, Juan and Sirini to this role. Then they would only have access to their own country data.

upvoted 12 times

...

0e18c76

1 year, 2 months ago

I agree that the correct answer is: Human Resources > False () Country > [Email] = USERPRINCIPALNAME () However, I wouldn't create two roles. Please be aware that if you create 2 roles and you assign the same person to the 2 roles, the result will work as an OR instead of an AND. This means, that even if you assign the CFO to the second role (False on Human Resources), he would still get access to all regions because he is assigned to the first role for Country. In this case, the solution is to create just one role and create two filters: - Human Resources > False () - Country > [Email] = USERPRINCIPALNAME () Then assign the CFO to the role Power BI Service. I presume, that the CFO is a Manager. Therefore in this contaxt the other Managers would not get access to the Human resources. Please check: https://www.youtube.com/watch?v=M5K_jKPxdqI

upvoted 1 times

...

vivian_data

1 year, 11 months ago

I agree

upvoted 1 times

JudT

1 year, 2 months ago

Understood now. Thank you very for your contribution. Much appreciated.

upvoted 2 times

...

Mabuse1

1 year, 10 months ago

For those who don't understand, watch this: https://www.youtube.com/watch?v=XMLXbbSgiM0 NB: False() restricts the entry to the table.

upvoted 7 times

...

SylUK

Most Recent 3 months, 3 weeks ago

The correct answer is : FALSE() and [Email]=Userprincipalname(). False() because CFO can only see USA sales data and the sales of others countries and he is restricted from accessing human resources' data.

upvoted 1 times

SylUK

3 months, 3 weeks ago

FALSE() expression when working with roles is explained here:https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance

upvoted 1 times

...

jaume

6 months, 4 weeks ago

We are creating 2 RLS roles... then , from the answer section should we assume the "Human Resources" condition will be applied to one role and "Country" to the other role? If so, since it's mentioned we are creating "Manager and CFO" roles, it would seems like "HR" would be condition for the firt role ("Manager") and "Country" would affect second role ("CFO") and cannot imagine how to set thet up. Only scenario I can imagine to achive what is requested would be: - Role "Manager" --> RLS filter "Country" --> [Email] = UPN - Role CFO --> RLS filter "HR" --> FALSE () It's harder to understand the question and imagine how to understand the answers than the specific topic allegedly is being evaluated

upvoted 1 times

...

8b7b763

8 months, 1 week ago

For CFO: Human Resources table -> False () For Managers: Country table-> [Email] = USERPRINCIPALNAME () CFO role only needs to be restricted in the hr table. manager role only needs to be restricted to their own country in the country table.

upvoted 1 times

...

nelrosell

9 months, 1 week ago

After thorought testing I found out that one of the given answer False() is not exactly right. If you only apply False() to the HR table then every manager can't see the Data. 1st requirement: • Each manager must see only the data in the Sales and Human Resources tables for their own country. Country: [Email] = USERPRINCIPALNAME() 2nd requirement: • The CFO must be prevented from seeing the data in the Human Resources table. Because there is no manager column for HR table, I have created a measure that returns select manager from Country table and use that measure to filter the HR table. HR: [Selected Manager] <> "CFO" <--this will return false otherwise true 3rd requirement The CFO must see the sales data of all countries. -no filter to apply I would say the selection of answers has to be corrected.

upvoted 1 times

...

28485e1

1 year, 3 months ago

Disregard my previous comment. I think I've figured it out. The header on the left selection says, "Table Filter DAX Expression." I think it's asking by which to filter OUT. Therefore, we only need to filter CFO out of HR and filter country by user.

upvoted 2 times

...

28485e1

1 year, 3 months ago

Are the CFO and managers different? I thought the CFO can't access HR? What is going on? What is it saying? This question is so stupid.

upvoted 1 times

...

Yawak

1 year, 3 months ago

Human Resource table -> False() -> Assign the CFO as member in PBI service Country -> [Email] = USERPRINCIPLENAME() -> Assign the other 3 managers in PBI service

upvoted 2 times

...

Abhi_1526

1 year, 3 months ago

First those they have very long .After reading the entire question and see then seeing options people will realise like "kahna kya chate ho ?(what)" We can't even do any guess.

upvoted 2 times

...

Parth_Mehta

1 year, 3 months ago

firstly, they asked for two roles but for which role we need to answer is not given Secondly, I do not think we can use column from different table while defining filter condition in mange roles. so for HR table, we can't have option b,c and for Country table, can't use option a ,c because for both the roles it will be wrong so answer colud be => for CFO role: HR : False() Country : True() (CFO should see the sale for all countries) =>for manager role: HR: True() (this table would be filtered by country table itself) Country: [email=userprinciple()]

upvoted 3 times

...

Dani_eL

1 year, 3 months ago

I simply don't get the question

upvoted 5 times

...

Male777

1 year, 5 months ago

Answer is Reciprocal of what it should have had been.. By the way correct values are choosen.

upvoted 1 times

...

JohnChung

1 year, 5 months ago

I think the correct answer is: Human Resource Table: [manager]="CFO" (Should filter the CFO out and return a false()) Country: [Email]= USERPRINCIPLENAME() (Direct managers other than CFO to their country data, both sales and human resources)

upvoted 1 times

...

Enrique67

1 year, 5 months ago

Hacen Falta tres expresiones DAX: Para Rol gerente, tanto pais como recursos humanos: [Correo electrónico] = USERPRINCIPALNAME () Para rol CFO , dos expresiones: Una en pais: [Correo electrónico] = USERPRINCIPALNAME () y otra en RRHH, true() para que vea todo

upvoted 1 times

...

ricardoamferreira18

1 year, 7 months ago

What it the correct answer?

upvoted 5 times

...

thomas_90

1 year, 8 months ago

In my opinion, because it can be assign users to each RLS so the correct answer is HR - False() and Country - USERPRINCIPLENAME(). So the CFO will be assign to the RLS of HR and other Managers will be assign to the RLS of Country.

upvoted 7 times

...

Load full discussion...