Multiple choice technology

In which type of cube we can use different aggregate operator for different measures?

  1. compressed cube

  2. non compressed cube

  3. none of the above

  4. all of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In non-compressed cubes, each measure can independently specify its own aggregate operator (SUM, AVG, COUNT, MIN, MAX) based on the measure's nature and business requirements. Compressed cubes store pre-aggregated data efficiently but lose this per-measure flexibility, typically using a single aggregation method. The non-compressed structure allows dimensional modeling tools to apply appropriate aggregations at query time.

Keep practicing — related questions