PL-300 Model the data Practice Question
Exhibit
{
"name": "policy1",
"policyType": "TableLevel",
"roles": [
{
"roleName": "SalesRegion",
"filterExpression": "[Region] = \"North\""
}
],
"tables": ["Sales"],
"filterExpression": "[Region] = \"South\""
}Refer to the exhibit. You are implementing row-level security (RLS) in Power BI. The JSON policy above is applied to the 'Sales' table. The user is in the 'SalesRegion' role. Which rows will the user see?
⚠ Common exam trap
Watch out — candidates often assume a role named 'SalesRegion' implies access to multiple regions, but the actual filter logic is determined solely by the explicit condition in the JSON policy, not the role name.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Rows where Region is 'North' only.
The JSON policy defines a filter that restricts the 'Sales' table to rows where the 'Region' column equals 'North'. The user is in the 'SalesRegion' role, which applies this filter. RLS in Power BI evaluates the filter expression for each row, returning only those that satisfy the condition, so only rows with Region = 'North' are visible.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Rows where Region is 'North' and 'South'.
Why it's wrong here
The role filter only shows 'North', not both.
- ✗
No rows, because there is a conflict.
Why it's wrong here
There is no conflict; the role filter takes precedence.
- ✓
Rows where Region is 'North' only.
Why this is correct
The role filter '[Region] = "North"' applies, ignoring the table-level filter.
- ✗
Rows where Region is 'South' only.
Why it's wrong here
The role filter overrides the table-level filter.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 217 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.