YouneedtomaintainthepartitionsontheProductOrderStatusmeasuregroup.Whatshouldyoudo?()

A.CreateaMicrosoftSQLServer2005IntegrationServices（SSIS）packagethataltersthepartitionqueriesandprocessesaggregatedpartitionseveryevening.

B.Enableproactivecachingonthepartitions.Setthecachetoupdateperiodicallywithalatencyof24hours.

C.Settherebuildintervalofthepartitionsto36hours.CreateaMicrosoftSQLServer2005IntegrationServices（SSIS）packagethatprocessesaggregatedpartitionseveryevening.

D.EnableproactivecachingontheProductOrderStatusmeasuregroup.Setscheduledpollingthatre-processesthemeasuregroupwheneverthesystemdateschange.