Questions Related to technology

Multiple choice technology
  1. Aggregate data should be stored in the original fact and dimension tables that contain the detail data

  2. Aggregate data has to be stored in separate fact tables but the same dimension tables can be used.

  3. Each level of aggregate data should be stored in separate set of fact and dimension tables.

  4. All levels of aggregation should be stored in a set of fact and dimension tables and the detailed data should be stored in separate fact and dimension table.

Reveal answer Fill a bubble to check yourself
C Correct answer