Microsoft
70-460 · Question #77
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 A. Use SQL Server Management Studio to create a role. 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
- AUse SQL Server Management Studio to create a role.
- BCreate a member and then create a Data Analysis Expressions (DAX) filter.
- CCreate a member and then create a Multidimensional Expressions (MDX) filter.
- DUse SQL Server Management Studio to create a role.
How the community answered
(18 responses)- A78% (14)
- B6% (1)
- C6% (1)
- D11% (2)
Community Discussion
No community discussion yet for this question.