You are designing a multidimensional OLAP (MOLAP) cube. The MOLAP cube must meet the following requirements: Ensure that workloads for aggregation tuning can be automatically collected. Require the…

SSAS query logging records actual user query patterns passively and automatically, satisfying the requirement for automatic workload collection without manual intervention. The captured log feeds directly into the Usage-Based Optimization Wizard, which analyses the logged queries and proposes or applies aggregations automatically, minimizing manual tuning effort. Because the wizard adds new aggregations without removing existing ones, previously tuned query paths retain their performance characteristics.

Creating multiple partitions improves parallel query processing but does not collect workload data or provide any automatic mechanism for designing or adjusting aggregations.

Multiple partitions alone address storage and parallelism, not automatic aggregation workload collection or the reduction of manual aggregation tuning effort.

Setting AggregationUsage to Full on natural key attributes forces aggregations to be built on those attributes but requires attribute-by-attribute manual configuration, does not collect workloads automatically, and can degrade previously optimized aggregation designs.