Exam PL-300 topic 2 question 8 discussion

The given answer is correct. A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function. C.For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

Ok, I agree with A and C but, "Each correct answer presents a complete solution" ? I believe that A and C are each one a part of solution not a complete solution... Am I worng?

A & B: Both USERNAME() and USEROBJECTID() can dynamically filter data based on the logged-in user, ensuring each manager only sees their country's data.

A (USERNAME function): This allows you to dynamically filter the data based on the logged-in user's email, thus achieving the requirement with a single RLS role. C (Apply security filter in both directions): This ensures the RLS role applies correctly across related tables, which is crucial for maintaining the data integrity and security filter throughout the model.

The correct answers are A and B, as both allow you to create a single role to filter data based on the manager’s identifier (email or object ID), minimizing the number of roles required.

A and E should be correct answer. A is obvious, and E because there is no reuirement to filter from details.

When RLS is applied, If the security filter in both direction is not applied, that users may or may not see information that is not related to him or her (depending on how the visuals are designed) Enable the security filter in both direction will ensure that only the required information is shown.

A is obvious. C does not represent a complete solution. What would happen if you ONLY apply security filter? What filter?? Security filter does not exist if this needs to be a complete solution. D - the only drawback is that you need a lot of roles.

the diagram shows the relationship already set as bi directional. Why we need to set this again ?

The given answer is correct

A&C. To people talking about "complete solutions," consider this: each Correct Selection is worth a point, but each Correct Answer is a complete solution. An Answer is composed of multiple selections, but the Answer itself will be a complete solution (of two parts). Hope this helps.

AC is correct

I will go with D, E

On June 8, 2024 exam

A can't be correct, Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function - USERNAME returns the Username, to get the User-E-Mail you have to use USERPRINCIPALNAME

I believe the given answer is not correct. Furthermore, I believe the most selected answer is incorrect as each option selected should be a complete solution. As mentioned in some other comments, the questions says that each solution should be a COMPLETE solution. If you in isolation performs option C, it would not lead to any RLS being applied in the model. If the question were asking for two alternatives that together were a complete solution, A and C would be correct. Hence, one should opt you alternative A and D where A is dynamic RLS and D is static RLS (credit to the individual(s) mentioning this prior to this comment).

A, D. A is dynamic while D is static RLS. Each presents a complete solution. The explanation in C itself is correct but irrelevant. The RLS filter required doesn't come from the Purchase Detail table.