nerdexam
Microsoft

70-466 · Question #94

You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which SSAS feature should you use?

The correct answer is B. Translation. SSAS Translations allow dimension hierarchy metadata to be displayed in different languages or locales, meeting multi-region reporting requirements without changing the underlying data structure.

Configure and maintain an analysis services database

Question

You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which SSAS feature should you use?

Exhibit

70-466 question #94 exhibit

Options

  • ACalculation
  • BTranslation
  • CAction
  • DPerspective

How the community answered

(62 responses)
  • A
    3% (2)
  • B
    71% (44)
  • C
    10% (6)
  • D
    16% (10)

Why each option

SSAS Translations allow dimension hierarchy metadata to be displayed in different languages or locales, meeting multi-region reporting requirements without changing the underlying data structure.

ACalculation

Calculations define computed values or named sets using MDX expressions and do not affect how hierarchy names or labels are displayed to users.

BTranslationCorrect

Translations in SSAS allow you to define locale-specific names for dimensions, hierarchies, levels, and members. When the Sales Regions hierarchy must surface different labels for different regional audiences, a Translation object maps the metadata to the appropriate language or locale at query time without altering cube structure.

CAction

Actions define interactive behaviors such as URL navigation or drill-through when a user clicks on a cube cell or member, not metadata localization.

DPerspective

A Perspective creates a filtered subset view of a cube to reduce complexity, but it does not provide language- or region-specific naming for hierarchies.

Concept tested: SSAS Translation for multilingual dimension metadata

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/translations-in-multidimensional-models-analysis-services

Topics

#SSAS translations#hierarchy modification#localization#Sales Regions

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice