nerdexam
Microsoft

70-448 · Question #184

You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database. This database includes a dimension named Product. You need to set the Dimension Data configurations to the…

The correct answer is B. You should consider adding the property: [Country].[USA],[Product].[Country].[UK]}. See the full explanation below for the reasoning.

Question

You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database. This database includes a dimension named Product. You need to set the Dimension Data configurations to the following:

Deny access to the {[Product].[Country].[UK],[Product].[Country].[USA]} configure of property users. You need to ensure that new users are added to the property by default. What should you do?

Options

  • AYou should consider adding the whole country members.
  • BYou should consider adding the property: [Country].[USA],[Product].[Country].[UK]}
  • CYou should consider adding the property: [Country].[USA],[Product].[Country].[UL]}
  • DYou should consider adding the property: [Country].[USA],[Product].[Country].[UK]}

How the community answered

(20 responses)
  • A
    15% (3)
  • B
    75% (15)
  • C
    5% (1)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice