Microsoft
70-460 · Question #7
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…
The correct answer is B. Add a row filter that implements the LOOKUPVALUE and USERNAME functions. See the full explanation below for the reasoning.
Question
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?
Options
- AAdd a row filter that implements only the USERNAME function.
- BAdd a row filter that implements the LOOKUPVALUE and USERNAME functions.
- CAdd a row filter that implements only the CUSTOMDATA function.
- DAdd a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.
How the community answered
(34 responses)- A3% (1)
- B71% (24)
- C18% (6)
- D9% (3)
Community Discussion
No community discussion yet for this question.