There is a logical fact table that contains Item number, store, time, and revenue. How would you
add Number of items sold?
A.
By creating a derived measure on the logical column Item number and using the count Function
B.
By creating a derived measure on the logical column item number and using the count distinct
function
C.
By creating a derived measure based on the physical column item number and changing the
aggregation method to count
D.
By creating a derived metric by using the Expression Builder
Explanation:
You should use a logical column (not physical). In fact,in the Explanation of the
exam, it displays a logical column.
It should be A.
Number of items sold may be required redundant records also for revenue generation.
C also is a valid answer
C is valid answer
It should be C!
C) is incorrect, the point is that the derived measure is based on logical model.