nerdexam
Microsoft

70-448 · Question #15

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

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

Question

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension named Account and a time dimension named Time. You have a fact table that contains a column named CurrentBalance. CurrentBalance contains the current account balance. You need to create a measure named AccountBalance from the CurrentBalance column to display the closing account balance for a time period. What should you do?

Options

  • ASet the AggregationFunction property of AccountBalance to Sum.
  • BSet the AggregationFunction property of AccountBalance to ByAccount.
  • CSet the AggregationFunction property of AccountBalance to LastNonEmpty.
  • DSet the AggregationFunction property of AccountBalance to FirstNonEmpty.

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