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

微软认证考试

题库首页>其他计算机考试>微软认证考试

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.
查看答案

微信扫一扫手机做题