Oracle Exam 1Z0-588 Topic 2 Question 59 Discussion

You maintain the Market hierarchy in DRM.

A target system needs an alternate hierarchy of the Market dimension that contains the lowest level of markets (city) rolling up by market size (nodes Large, Medium, and Small).

Identify the ways to meet this requirement in DRM.

1. Create a property category called "Market Size" and populate the values as "Large", "Medium", and "Small"

2. Create a property called "Market Size" and populate the values as "Large", "Medium", and "Small"

3. Create a node type called "Market Size" and populate the values as "Large", "Medium", and "Small"

4. Create an alternate hierarchy in the Market dimension with nodes "Large", "Medium", and "Small". Add cities as shared nodes under the appropriate Market Size nodes.