how is data stored in the Star Schema, if the data is loaded nightly?

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

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

A.
The highest level of aggregation

B.
Multiple levels of aggregation

C.
Independently from aggregation level

D.
The lowest level of aggregation



Leave a Reply 3

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


Thom

Thom

Exam is exactly like these questions.
Took it a week ago and all the questions I could find here.
Thank you, guys.

Jitendra Atri

Jitendra Atri

Hi Thom,

could you please suggest the correct answer to the below question

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

A.
The highest level of aggregation

B.
Multiple levels of aggregation

C.
Independently from aggregation level

D.
The lowest level of aggregation