A.CreateaMicrosoftSQLServer2005IntegrationServices(SSIS)packagethataltersthepartitionqueriesandprocessesaggregatedpartitionseveryevening.
B.Enableproactivecachingonthepartitions.Setthecachetoupdateperiodicallywithalatencyof24hours.
C.Settherebuildintervalofthepartitionsto36hours.CreateaMicrosoftSQLServer2005IntegrationServices(SSIS)packagethatprocessesaggregatedpartitionseveryevening.
D.EnableproactivecachingontheProductOrderStatusmeasuregroup.Setscheduledpollingthatre-processesthemeasuregroupwheneverthesystemdateschange.
参考答案:A