首页 文档 ACreateaMicrosoftSQLServer2005IntegrationServices(SSIS)pack

ACreateaMicrosoftSQLServer2005IntegrationServices(SSIS)pack

A.CreateaMicrosoftSQLServer2005IntegrationServices(SSIS)packagethataltersthepartitionqueriesandprocessesaggregatedpartitionseveryevening.

B.Enableproactivecachingonthepartitions.Setthecachetoupdateperiodicallywithalatencyof24hours.

C.Settherebuildintervalofthepartitionsto36hours.CreateaMicrosoftSQLServer2005IntegrationServices(SSIS)packagethatprocessesaggregatedpartitionseveryevening.

D.EnableproactivecachingontheProductOrderStatusmeasuregroup.Setscheduledpollingthatre-processesthemeasuregroupwheneverthesystemdateschange.

参考答案:A

本文来自网络,不代表煤炭资讯立场。转载请注明出处: http://www.mtxh.cn/bk/wd-bk/414346.html
上一篇
下一篇

作者: Anita

为您推荐

返回顶部