ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 68 discussion

Actual exam question from Microsoft's PL-300
Question #: 68
Topic #: 2
[All PL-300 Questions]

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 Hide Answer
Suggested Answer:
by Erick94 at April 1, 2023, 3:11 a.m.

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
Submit Cancel
semauni
Highly Voted 2 years, 3 months 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
4 months, 3 weeks 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, 4 months ago
I thought, I was the only one
upvoted 4 times
...
...
saraplez
Highly Voted 2 years, 1 month 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, 5 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, 3 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
2 years ago
I agree
upvoted 1 times
JudT
1 year, 4 months ago
Understood now. Thank you very for your contribution. Much appreciated.
upvoted 2 times
...
...
Mabuse1
2 years 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
...
...
Lulu_2022
Most Recent 1 month ago
This does not look right. In country It should be FALSE(). And we had same question before with the answer using False.
upvoted 1 times
...
Lulu_2022
1 month, 1 week ago
🔹 Human Resources Table (CFO Role) To prevent the CFO from seeing any data in this table: FALSE() This blocks all rows from being visible to the CFO. 🔹 Country Table (Manager Role) To allow each manager to see data only for their own country: Country[Country] = LOOKUPVALUE(Employee[Country], Employee[Email], USERPRINCIPALNAME()) This assumes you have a mapping between the user’s email and their assigned country in an Employee or similar table.
upvoted 1 times
...
SylUK
5 months, 1 week 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
5 months, 1 week 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
8 months, 2 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
9 months, 3 weeks 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
11 months 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 months ago
I simply don't get the question
upvoted 5 times
...
Male777
1 year, 6 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, 6 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, 7 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
...
Load full discussion...
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