Microsoft
70-467 · Question #29
70-467 Question #29: Real Exam Question with Answer & Explanation
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.
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
Options
- AOption A
- BOption B
- COption C
- DOption D
Explanation
Returning only blue products from the Category hierarchy requires an MDX set expression that correctly filters Category members by their associated Color attribute value.
Common mistakes.
- 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.
- 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.
- 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
Community Discussion
No community discussion yet for this question.