Which is the correct answer to execute the Usage-Based Optimization Wizard you should make query logging enable?

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. Which is the correct answer?

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. Which is the correct answer?

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.

Explanation:
Enabling the Query Log
The query log captures the query activity as users and applications interact with the server.
To enable the query log in SSMS, right-click the Analysis Services server node, and then select Properties. Next, in the Analysis Server Properties dialog box, shown in Figure 8-20, set the QueryLog properties

Table 8-4 QueryLog Properties
Property Description
CreateQueryLogTable When set to True and if the server account has sufficient privileges, the server will create the log table if it does not already exist.
QueryLogConnectionString A valid connection string to a SQL Server database; the query log is disabled if this property is empty.
QueryLogSampling The frequency for query sampling. By default, every tenth query is logged.
QueryLogTableName The name of the table in a SQL Server database that will capture the query statistics. The default table name is OlapQueryLog



Leave a Reply 0

Your email address will not be published. Required fields are marked *