You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard you should make query logging enable.

A. You should make the QueryLogSampling server attribute default value.
B. You should make the QueryLogSampling server attribute 5.
C. You should configure the server property of DefaultFolders.
D. You should configure the QueryLogConnectionString server attribute and set a valid connection string.

Ans:  D

0 comments: