Microsoft Certified: Power BI Data
Analyst Associate Exam Actual
Questions and Answers 2026
DAX -
correct answer ✅Data Analysis Expressions (DAX) is a library of
functions and operators that can be combined to build formulas
and expressions in Power BI, Analysis Services, and Power Pivot in
Excel data models.
Star Schema -
correct answer ✅n computing, the star schema is the simplest
style of data mart schema and is the approach most widely used to
develop data warehouses and dimensional data marts. The star
schema consists of one or more fact tables referencing any number
of dimension tables
Static Row Level Security -
correct answer ✅uses a fixed value in the DAX filter, while the
dynamic method uses a DAX function.
In Power BI select Modeling tab, then Manage Roles. Create a role
for each department and then add a DAX expression to it. For
instance, you can create a role called Game and then add the DAX
expression [department] = "Game". Then, whenever a member of
, Microsoft Certified: Power BI Data
Analyst Associate Exam Actual
Questions and Answers 2026
that role interacts with the report, Power BI will add that filter to
their interactions, thus limiting what they see.
Test Roles in Power BI -
correct answer ✅selecting the Modeling tab and then selecting
View as Roles. In the View as roles window, select the Game role.
The report now renders as if you were in that role, and you will only
see the records that are included in the Game department.
Deploy Roles in Power BI -
correct answer ✅selecting the Publish button on the Home tab
and then selecting a workspace.
Add members to the role -
correct answer ✅go to your workspace in Power BI service. Find
the dataset that you created with the same name as your report.
Select the ellipsis (...) button and then select Security.
add Microsoft Azure Active Directory (Azure AD) users and security
groups to the security role. When members are added to this role,
the DAX filter that you previously defined will be applied to them. If
members are not added to the role, but they have access to the
report, RLS will not apply to them.
Analyst Associate Exam Actual
Questions and Answers 2026
DAX -
correct answer ✅Data Analysis Expressions (DAX) is a library of
functions and operators that can be combined to build formulas
and expressions in Power BI, Analysis Services, and Power Pivot in
Excel data models.
Star Schema -
correct answer ✅n computing, the star schema is the simplest
style of data mart schema and is the approach most widely used to
develop data warehouses and dimensional data marts. The star
schema consists of one or more fact tables referencing any number
of dimension tables
Static Row Level Security -
correct answer ✅uses a fixed value in the DAX filter, while the
dynamic method uses a DAX function.
In Power BI select Modeling tab, then Manage Roles. Create a role
for each department and then add a DAX expression to it. For
instance, you can create a role called Game and then add the DAX
expression [department] = "Game". Then, whenever a member of
, Microsoft Certified: Power BI Data
Analyst Associate Exam Actual
Questions and Answers 2026
that role interacts with the report, Power BI will add that filter to
their interactions, thus limiting what they see.
Test Roles in Power BI -
correct answer ✅selecting the Modeling tab and then selecting
View as Roles. In the View as roles window, select the Game role.
The report now renders as if you were in that role, and you will only
see the records that are included in the Game department.
Deploy Roles in Power BI -
correct answer ✅selecting the Publish button on the Home tab
and then selecting a workspace.
Add members to the role -
correct answer ✅go to your workspace in Power BI service. Find
the dataset that you created with the same name as your report.
Select the ellipsis (...) button and then select Security.
add Microsoft Azure Active Directory (Azure AD) users and security
groups to the security role. When members are added to this role,
the DAX filter that you previously defined will be applied to them. If
members are not added to the role, but they have access to the
report, RLS will not apply to them.
