nerdexam
Microsoft

70-448 · Question #154

70-448 Question #154: Real Exam Question with Answer & Explanation

Sign in or unlock 70-448 to reveal the answer and full explanation for question #154. The question stem and answer options stay visible for context.

Question

You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. 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?

Exhibit

70-448 question #154 exhibit

Options

  • AThe QueryLogSampling server property should be set to 10
  • BThe LogDir server property should be set to a valid path.
  • CThe QueryLogConnectionString server property should be set to a valid connection string.
  • DThe AllowedBrowsingFolders server property should be set to include the folder from the LogDir setting.

Unlock 70-448 to see the answer

You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-448 Practice