nerdexam
Microsoft

70-460 · Question #56

You need to implement security in the cube to limit the sites visible to each user. What should you do?

The correct answer is C. Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to. See the full explanation below for the reasoning.

Question

You need to implement security in the cube to limit the sites visible to each user. What should you do?

Options

  • ACreate an SSAS database role in the cube for each user and assign the sites each user can access
  • BCreate an SSAS server role for each user and assign the sites each user can access to his or her
  • CCreate an SSAS database role and define a Multidimensional Expressions (MDX) calculation to
  • DCreate a view on the SalesTransactions table that uses the SecurityFilter and User table data to

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    75% (18)
  • D
    13% (3)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice