Microsoft
70-467 · Question #136
70-467 Question #136: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #136. The question stem and answer options stay visible for context.
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 the LOOKUPVALUE and CUSTOMDATA functions.
- BAdd a row filter that implements only the USERNAME function.
- CAdd a row filter that implements the LOOKUPVALUE and USERNAME functions.
- DAdd a row filter that implements only the CUSTOMDATA function.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.