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 Usage-Based 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 LogQueryLog properties. Set the LogQuery-LogCreateLogTable property to True so that the server can create the table. Set LogQueryLogQueryLogConnectionString property to specify a valid connection string to the SSAS_Logging database. Change the LogQueryLogQueryLogSampling property to 5 to sample every fi fth query. Last, change the LogQueryLogQueryLogTablename property to QueryLog.
