题目

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、APTT延长,PT正常

B、APTT正常,PT延长

C、APTT延长,PT延长

D、APTT正常,PT正常

E、APTT正常,TT延长

正常骨髓象的粒细胞系统约占有核细胞的()。

A、50%~60%

B、20%~30%

C、30%~40%

D、40%~50%

E、10%~20%

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance is managed by you. The security requirements should be designed for a new database application. A code segment is utilized by the application, and the code segment includes the following components: A method that the registry is accessed on the SQL Server, a method that the file system is accessed on a network file server, and a class definition that public static fields are utilized. SQL CLR integration is utilized by the code segment, and the code segment is implemented as a single assembly. Since you are the technical support, you are required to make sure that the application should be successfully deployed to the instance.    Which action will you perform?()

A、The SAFE code access security should be utilized for the assembly.

B、All public static fields should be replaced with public fields.

C、All public static fields should be utilized with public static read-only fields. And then the assembly shouldbe registered by utilizing the regasm.exe utility before deployment.

D、All public static fields should be replaced with public static read-only fields. And then the EXTERNAL_ACCESS code access security should be utilized for the assembly.

You need to resolve the double counting of transactions issue in the existing reports. What should you do?()

A、Apply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.

B、Apply a Conditional Split transformation in the Transaction data in the SSIS package.

C、Delete the AccountHolder table in the WoodgroveDW database.

D、Apply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.

G-6-PD缺乏症患者的葡萄糖-6-磷酸脱氢酶活性()。

A、正常

B、减低

C、增高

D、正常或减低

E、正常或增高

最新解答的试题