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?
Sign in or unlock 1Z0-591 to reveal the answer and full explanation for question #71. The question stem and answer options stay visible for context.
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
Unlock 1Z0-591 to see the answer
You've previewed enough free 1Z0-591 questions. Unlock 1Z0-591 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#derived measures#count distinct#logical columns#aggregation functions