Microsoft
70-448 · Question #252
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You plan to run the Usage-Based Optimization Wizard. You need to enable query logging. What should you do?
The correct answer is D. Set the QueryLogConnectionString server property to a valid connection string. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. You plan to run the Usage-Based Optimization Wizard. You need to enable query logging. What should you do?
Options
- ASet the LogDir server property to a valid path.
- BSet the QueryLogSampling server property to 10.
- CSet the AllowedBrowsingFolders server property to include the folder from the LogDir setting.
- DSet the QueryLogConnectionString server property to a valid connection string.
How the community answered
(25 responses)- A12% (3)
- B4% (1)
- C4% (1)
- D80% (20)
Community Discussion
No community discussion yet for this question.