nerdexam
Microsoft

70-448 · Question #29

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. A sales manager called Clerk is responsible for the sales of bikes in the Northeast region. You decide to give…

The correct answer is C. You should increase Clerk to a new role which owns components below. See the full explanation below for the reasoning.

Question

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. A sales manager called Clerk is responsible for the sales of bikes in the Northeast region. You decide to give some rights to the rights to Clerk to visit the database. You won two roles below called Northeast Region and Bikes. Their schemas are listed below:

  • You have make The Visual Totals properties attribute true for roles

above.

  • You should make sure that Clerk could browser the workers in the

Product dimension which link to the Bikes category in the Northeast region. Which is the correct answer?

Options

  • AYou should increase Clerk to a Bikes role
  • BYou should increase Clerk to the Northeast Region role.
  • CYou should increase Clerk to a new role which owns components below:
  • DYou should increase Clerk to the default Region role.

How the community answered

(43 responses)
  • A
    9% (4)
  • B
    2% (1)
  • C
    74% (32)
  • D
    14% (6)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice