多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You need to maintain the partitions on the ProductOrderStatus measure group. What should you do?()

  • 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.
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题