nerdexam
Microsoft

70-448 · Question #87

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

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

Question

You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. There is a dimension called Product and a time dimension called TestTimer in your solution. You own a fact table which includes a column called ProductBalance which includes the current account balance. You should make sure that you develop a measure called Test ProductBalance from the TestBalance column to show the closing account balance for some times. Which is the correct answer?

Options

  • AYou should configure the AggregationFunction property of ProductBalance to Total.
  • BYou should configure the AggregationFunction property of ProductBalance to ByProduct.
  • CYou should configure the AggregationFunction property of ProductBalance to LastNonEmpty.
  • DYou should configure the AggregationFunction property of ProductBalance to FirstEmpty.

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