nerdexam
Microsoft

70-467 · Question #29

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy…

The correct answer is C. Option C. Returning only blue products from the Category hierarchy requires an MDX set expression that correctly filters Category members by their associated Color attribute value.

Design BI data models

Question

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy. You need to return only the blue products in the Category hierarchy. Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

Exhibit

70-467 question #29 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(15 responses)
  • A
    7% (1)
  • B
    13% (2)
  • C
    80% (12)

Why each option

Returning only blue products from the Category hierarchy requires an MDX set expression that correctly filters Category members by their associated Color attribute value.

AOption A

Option A likely uses incorrect syntax or a function that does not properly traverse the attribute relationship between the Category and Color hierarchies, producing incorrect or empty results.

BOption B

Option B likely filters at the wrong granularity or uses a method that fails when Category members are associated with multiple colors, returning incorrect members.

COption CCorrect

The correct MDX expression uses EXISTS or FILTER to intersect Category hierarchy members with those linked to the Blue member of the Color attribute hierarchy, respecting the attribute relationship defined in the dimension. This approach returns only Category members that have at least one associated blue product, which is the standard and most performant MDX pattern for cross-attribute set filtering.

DOption D

Option D likely uses a scalar function or non-set expression that cannot be used as a named set definition, or returns all Category members rather than filtering by color.

Concept tested: MDX named set filtering using EXISTS or FILTER across attribute hierarchies

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/building-named-sets-in-mdx

Topics

#MDX named sets#attribute filtering#dimension hierarchies#SSAS

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice