How would you add Number of items sold?

There is a logical fact table that contains Item number, store, time, and revenue. How would you
add Number of items sold?

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.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Pranay

Pranay

It should be A.
Number of items sold may be required redundant records also for revenue generation.

Karthik

Karthik

C also is a valid answer

Ashish

Ashish

C is valid answer

Pedro

Pedro

It should be C!

Leo Yu

Leo Yu

C) is incorrect, the point is that the derived measure is based on logical model.