nerdexam
Microsoft

70-768 · Question #61

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…

The correct answer is C. Create a perspective for the sales team. See the full explanation below for the reasoning.

Question

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?

Options

  • ACreate a separate partition for each team.
  • BCreate a separate data source for each team.
  • CCreate a perspective for the sales team.
  • DEnable client side security to filter non-sales data.

How the community answered

(14 responses)
  • A
    7% (1)
  • B
    7% (1)
  • C
    86% (12)

Community Discussion

No community discussion yet for this question.

Full 70-768 Practice