网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
YouneedtomaintainthepartitionsontheProductOrderStatusmeasuregroup.Whatshouldyoudo?()

A.CreateaMicrosoftSQLServer2005IntegrationServices(SSIS)packagethataltersthepartitionqueriesandprocessesaggregatedpartitionseveryevening.

B.Enableproactivecachingonthepartitions.Setthecachetoupdateperiodicallywithalatencyof24hours.

C.Settherebuildintervalofthepartitionsto36hours.CreateaMicrosoftSQLServer2005IntegrationServices(SSIS)packagethatprocessesaggregatedpartitionseveryevening.

D.EnableproactivecachingontheProductOrderStatusmeasuregroup.Setscheduledpollingthatre-processesthemeasuregroupwheneverthesystemdateschange.


参考答案

更多 “ YouneedtomaintainthepartitionsontheProductOrderStatusmeasuregroup.Whatshouldyoudo?() A.CreateaMicrosoftSQLServer2005IntegrationServices(SSIS)packagethataltersthepartitionqueriesandprocessesaggregatedpartitionseveryevening.B.Enableproactivecachingonthepartitions.Setthecachetoupdateperiodicallywithalatencyof24hours.C.Settherebuildintervalofthepartitionsto36hours.CreateaMicrosoftSQLServer2005IntegrationServices(SSIS)packagethatprocessesaggregatedpartitionseveryevening.D.EnableproactivecachingontheProductOrderStatusmeasuregroup.Setscheduledpollingthatre-processesthemeasuregroupwheneverthesystemdateschange. ” 相关考题