A lot of times its because you want want a rollup table but also need to answer cardinality questions. So instead of scanning millions of rows you can have a single rolled up array that you can perform set operations on other rolls (instead of a numeric aggregate that does not have the appropriate mathematical properties to do much with).