A、Create a Microsoft SQL Server 2005 Integration Services （SSIS） package that alters the partition queries and processes aggregated partitions every evening.

B、Enable proactive caching on the partitions. Set the cache to update periodically with a latency of 24 hours.

C、Set the rebuild interval of the partitions to 36 hours. Create a Microsoft SQL Server 2005 Integration Services （SSIS） package that processes aggregated partitions every evening.

D、Enable proactive caching on the ProductOrderStatus measure group. Set scheduled polling that re-processes the measure group whenever the system dates change.