You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used
by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team
does not need any information other than sales-related resources in the tabular model. The
finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing
development and administrative effort.

What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used
by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team
does not need any information other than sales-related resources in the tabular model. The
finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing
development and administrative effort.

What should you do?

A.
Create a separate partition for each team.

B.
Create a separate data source for each team.

C.
Create a perspective for the sales team.

D.
Enable client side security to filter non-sales data.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Ralph

Ralph

Yes.”c” is correct answer. Perspective can be used as a way of making the model easier. BTW perspective cannot be used as security mechanism.

Youri

Youri

C is Correct