Multiple choice technology enterprise content management

Can the same fact with different aggregate layers be put in the same table

  1. As long as the aggregate facts refer to keys in appropriate layer in the dimsension

  2. Multiple aggregate levels can be stored in different tables

  3. Aggregated facts should not be stored in the physical tables, they must always be calculated on the fly

  4. A and B

  5. All of the above
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

Aggregate facts at different levels can share the same physical table as long as each fact references dimension keys at its appropriate grain. Alternatively, different aggregate levels can be stored in separate tables for performance or clarity. Option C is incorrect because pre-aggregated facts are commonly stored in physical tables rather than calculated on the fly.

Keep practicing — related questions