SAP
C_TBW60_74 · Question #91
Your reporting end-users have noticed that several Basic InfoCube queries are staring to run more slowly. After examination of the InfoCube, you notice that 2 out of 7 user-defined Dimensions are…
See the full explanation below for the reasoning.
Question
Your reporting end-users have noticed that several Basic InfoCube queries are staring to run more slowly. After examination of the InfoCube, you notice that 2 out of 7 user-defined Dimensions are approaching 50% the size of the Fact Table. What action should you take to resolve this? There are 2 correct answers.
Options
- ARemodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange
- BRemodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange
- CRemodel the Cube by moving the high-cardinality Characteristics from these Dimensions into one
- DRemodel the Cube by creating more Dimensions making as many of them as possible into Line-
Community Discussion
No community discussion yet for this question.