PrepAway - Latest Free Exam Questions & Answers

You need to configure the Employees roles so that users…

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee.
The table contains employee details, including the sales territory for each employee.
The table also defines a column named EmployeeAlias which contains the Active Directory Domain Services
(AD DS) domain and logon name for each employee.
You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for their respective sales
territory.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.

B.
Add a row filter that implements the LOOKUPVALUE and USERNAME functions.

C.
Add a row filter that implements only the USERNAME function.

D.
Add a row filter that implements only the CUSTOMDATA function.

One Comment on “You need to configure the Employees roles so that users…


Leave a Reply