Microsoft
70-768 · Question #56
You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution. You need to grant permission for salespersons to view only the data based on their sales…
The correct answer is D. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution. You need to grant permission for salespersons to view only the data based on their sales territory. What should you do?
Options
- ACreate a member and then create a Multidimensional Expressions (MDX) filter.
- BCreate a member and then create a Data Analysis Expressions (DAX) filter.
- CUse SQL Server Management Studio to create a role. Then create a Multidimensional
- DUse SQL Server Management Studio to create a role. Then create a Data Analysis Expressions
How the community answered
(16 responses)- A6% (1)
- B6% (1)
- C19% (3)
- D69% (11)
Community Discussion
No community discussion yet for this question.