Oracle
1Z0-591 · Question #71
There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?
The correct answer is B. By creating a derived measure on the logical column item number and using the count distinct function. You should use a logical column (not physical). In fact,in the Explanation of the exam, it displays a logical column.
Developing the Business Model and Mapping Layer of a Repository
Question
There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?
Options
- ABy creating a derived measure on the logical column Item number and using the count Function
- BBy creating a derived measure on the logical column item number and using the count distinct function
- CBy creating a derived measure based on the physical column item number and changing the aggregation
- DBy creating a derived metric by using the Expression Builder
How the community answered
(29 responses)- A7% (2)
- B76% (22)
- C3% (1)
- D14% (4)
Explanation
You should use a logical column (not physical). In fact,in the Explanation of the exam, it displays a logical column.
Topics
#derived measures#count distinct#logical columns#aggregation functions
Community Discussion
No community discussion yet for this question.