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…

Question

Options

• AYou should make the QueryLogSampling server attribute default value.
• BYou should make the QueryLogSampling server attribute 5.
• CYou should configure the server property of DefaultFolders.
• DYou should configure the QueryLogConnectionString server attribute and set a valid connection string.

• A
  3% (1)
• B
  5% (2)
• C
  14% (5)
• D
  78% (29)

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 Next, in the Analysis Server Properties dialog box, shown in Figure 8-20, set the QueryLog 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

No community discussion yet for this question.