Question

1. Which (choose ONLY one) of the following statements is/are true about Dimension Hierarchies (HIERs), Levels (LVLs), and Members (MBRs) in an MDM:

1. For each LVL in the HIER, the number of MBRs in that level must be less than the number of MBRs in this LVL's parent LVL
2. For each LVL in the HIER, the number unique values for any DATT in that level cannot be greater than the number of MBRs in that level
3. For each LVL in the HIER, the number of MBRs in that level must be greater than the number of MBRs in this LVL's parent LVL
4. For each LVL in the HIER, the number unique values for any DATT in that level cannot be less than the number of MBRs in that level

Answer 1

Answer)

It is the option 4.

Every program would have no parts in reproducing or transmitting any of the information where the relational data and multidimensional data could be joined in a single SQL query. The CEIL function would return the smallest whole number which is much greater than the MBRs. This would have hierarchies that would be level-based and it has the schema which would not be using parent-child.

Please comment in case you need any other inputs.
Please share a like if you find the answer helpful.
Thank you.