PrepAway - Latest Free Exam Questions & Answers

You need to grant permission for salespersons to view o…

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Create a member and then create a Data Analysis Expressions (DAX) filter.

B.
Create a member and then create a Multidimensional Expressions (MDX) filter.

C.
Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.

D.
Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.


Leave a Reply