Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
semauni
Highly Voted 1 year, 7 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 84 times
660091f
7 months, 3 weeks ago
I thought, I was the only one
upvoted 3 times
...
...
saraplez
Highly Voted 1 year, 5 months 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 64 times
0e18c76
7 months, 1 week 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
...
SilentAnalyst
9 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 9 times
...
vivian_data
1 year, 4 months ago
I agree
upvoted 1 times
JudT
8 months ago
Understood now. Thank you very for your contribution. Much appreciated.
upvoted 2 times
...
...
Mabuse1
1 year, 3 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
...
...
jaume
Most Recent 6 days, 13 hours 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
1 month, 2 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
2 months, 3 weeks 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
8 months, 3 weeks 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
8 months, 3 weeks 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
8 months, 3 weeks 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
9 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
9 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 2 times
...
Dani_eL
9 months, 1 week ago
I simply don't get the question
upvoted 5 times
...
Male777
10 months, 2 weeks ago
Answer is Reciprocal of what it should have had been.. By the way correct values are choosen.
upvoted 1 times
...
JohnChung
10 months, 3 weeks 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
11 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, 1 month ago
What it the correct answer?
upvoted 5 times
...
thomas_90
1 year, 1 month 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
...
Igetmyrole
1 year, 2 months ago
[manager]="CFO' [Email] = userprinciplaname() [manager]="CFO': ensures that only the "CFO" role can see Human Resources data for the USA. [Email] = userprinciplaname(): ensures that each manager sees only their country's data in the Sales and Human resources tables.
upvoted 1 times
ab97776
7 months, 3 weeks ago
CFO isn't supposed to see any human resources information, so "false()" works better. if there were a manager column in HR table, he could then see human resources info where CFO is listed
upvoted 1 times
...
Elfmo11
1 year, 2 months ago
From the question:"The CFO must be prevented from seeing the data in the Human Resources table." So your logic about the CFO does not hold right?
upvoted 6 times
...
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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