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 LogThe 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