Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Medium
Question 22
This question is part of repeated scenario questions that contain a similar stem but with a different solution for each question. You need to identify if the given solution solves a particular problem. Each set of repeated scenario questions might contain either none, one, or many solutions.
You create a Power BI model (shown below) to analyze the yearly income of your customers across different occupations and sales territories.
You have to grant report access so users can view customer’s income data only for the high-profile occupation Management in the Sales Territory Region Germany.
Solution: You create a row-level security role. This role contains two filters:
DimSalesTerritory[Sales Territory Region] = "Germany" and DimCustomer[Occupation] = "Management"
You assign this role to the user.
Does the solution meet the goal?
-
A
Yes
-
B
No
Reveal correct answer
Correct answer: A
Explanation
Instead of two separate roles, we create just one role Management & Germany which filters both the tables DimCustomer and DimSalesTerritory.
The role filters the DimSalesTerritory table where the Sales Territory Region is 'Germany.'
And the same role filters the DimCustomer table where Occupation is 'Management.'
If you test the report for the role Management & Germany, you will see only the records where Occupation is ‘Management’ and Sales Territory Region is ‘Germany.’
In other words, the resulting data is an intersection of both the filter values, not the union. The given solution meets the goal. Option Yes is the correct answer.
Reference Link: https://community.powerbi.com/t5/Desktop/RLS-Users-with-multiple-roles-filter-problem/td-p/1044670
PBIX File Link: RLS Anded
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
