When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?

B. The highest level of aggregation

A. The lowest level of aggregation

C. Multiple levels of aggregation

D. Independently from aggregation level

Quiz

Untitled

marcusfontess 2 questions

Take the quiz

1When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?
1. AA. The lowest level of aggregation
2. BB. The highest level of aggregation
3. CC. Multiple levels of aggregation
4. DD. Independently from aggregation level
2The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.
1. AA. $10,000
2. B
  B. 0
3. C
  C. 1
4. DD. Year