You have a measure group that contains several partitions. One of the partitions stores historical data for several years and is rarly queried. You need to select storage mode that saves storage space on the SSAS server, but you still want to take advantage of aggregations.
How should you configure these partitions?
1. Set the partition's StorageMode property to HOLAP and define aggregation on the partition.
2. Use the Automatic MOLAP Proactive Caching setting.
3. Set the partition's StorageMode property to ROLAP, set the Slice property to the date dimension member that defines the underlying historical data, and define aggregations on the partition.
4. Set the partition's StorageMode property to MOLAP.
Answer: 1 only
With HOLAP, SSAS stores aggregations in SSAS, but the underlying data remains in the relational database.
ROLAP, which contains no aggregations, consumes the least storage space because the all the data is left in the relational database.
With ROLAP, aggregations are not stored in SSAS.
When you define a partition with a MOLAP storage mode, both the data and the aggregations are stored in SSAS.