Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are developing a Power BI sales report that connects to a semantic model. The model contains a Sales table with transaction data and an Employees table that includes an EmailAddress column storing each employee's User Principal Name (UPN). You must implement dynamic row-level security (RLS) so that each salesperson sees only their own sales. The Employees table is related to the Sales table.

Which DAX expression should you use in the role definition to achieve this?

  • Create a role on the Employees table with the expression [EmailAddress] = USERPRINCIPALNAME().

  • Create a role on the Sales table with the expression [EmailAddress] = USERPRINCIPALNAME().

  • Create a role on the Employees table with the expression [EmailAddress] = USERNAME().

  • Create a role in the Power BI service and add members, but leave the table filter blank so the system handles security automatically.

Microsoft Power BI Data Analyst
Manage and secure Power BI
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot