nerdexam
Microsoft

70-448 · Question #21

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named Customer. The Customer dimension has the attributes named Country and State. The Country attribute has…

The correct answer is B. Set the OrderBy property to AttributeName and the OrderByAttribute property to Country for the State attribute. See the full explanation below for the reasoning.

Question

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named Customer. The Customer dimension has the attributes named Country and State. The Country attribute has the following components:

  • The KeyColumn property is set to the country code.
  • The NameColumn property is set to the country name.

You create an attribute relation between the Country attribute and the State attribute. You need to ensure that the state names are sorted first by the country name and then by the state name. What should you do?

Options

  • ASet the OrderBy property to Name and the OrderByAttribute property to Country for the State attribute.
  • BSet the OrderBy property to AttributeName and the OrderByAttribute property to Country for the State attribute.
  • CSet the OrderBy property to Name for the Country attribute.
  • DSet the OrderBy property to Name for the Country attribute.

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    83% (29)
  • C
    3% (1)
  • D
    11% (4)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-448 Practice