70-470 Latest Exam Braindumps
Question 3: 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?
A. Add a row filter that implements only the USERNAME function.
B. Add a row filter that implements the LOOKUPVALUE and USERNAME functions.
C. Add a row filter that implements only the CUSTOMDATA function.
D. Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.
Correct Answer: B
