You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) instance.
Now you get an e-mail from your company CIO, in the e-mail he wants you to run the UsageBased Optimization Wizard.
You have to enable query logging. What action should you perform?
A.
The QueryLogSampling server property should be set to 10
B.
The LogDir server property should be set to a valid path.
C.
The QueryLogConnectionString server property should be set to a valid connection string.
D.
The AllowedBrowsingFolders server property should be set to include the folder from the
LogDir setting.
Explanation:
After you set the QueryLogConnectionString property, the server will attempt to establish a
connection by using the connection string you specifi ed in the QueryLogConnectionString
property. If the connection fails, the SSAS service ignores the error. Monitor the Windows
event log for error messages if no queries are logged in the query log. EXAM TIP you want
to run the usage-Based optimization Wizard to produce an aggregation design based on the
actual server usage. you have a SQL Server database named SSAS_Logging. you want to
confi gure the server properties to save every fi fth query to a table named QueryLog inside
the SSAS_Logging database. Which server properties do you need to change? you need to
change all of the four Log\QueryLog properties. Set the Log\Query-Log\CreateLogTable
property to True so that the server can create the table. Set Log\QueryLog
\QueryLogConnectionString property to specify a valid connection string to the
SSAS_Logging database. Change the Log\QueryLog\QueryLogSampling property to 5 to
sample every fi fth query. Last, change the Log \QueryLogQueryLogTablename property to
QueryLog.
