Explanation:It may be helpful to think of the UPDATE CUBE statement as a subroutine that will automatically generate a series of individual cell writeback operations to leaf and non-leaf cells that will roll up into a specified sum. 8. When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes.
A. USE_EQUAL_ALLOCATION
B. USE_WEIGHTED_ALLOCATION
C. USE_WEIGHTED_INCREMENT
D. All of the mentioned
Answer:A
Explanation:It may be helpful to think of the UPDATE CUBE statement as a subroutine that will automatically generate a series of individual cell writeback operations to leaf and non-leaf cells that will roll up into a specified sum. 8. When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes.
A. USE_EQUAL_ALLOCATION B. USE_WEIGHTED_ALLOCATION C. USE_WEIGHTED_INCREMENT D. All of the mentioned
Explanation:Every leaf cell that contributes to the updated cell will be assigned an equal value 9. Which of the following is valid syntax for DRILLTHROUGH statement ?