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

Sem título

marcusfontess 2 perguntas

Fazer o 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