Microsoft
70-448 · Question #274
70-448 Question #274: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #274. The question stem and answer options stay visible for context.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the following exhibit. (Click the Exhibit button.) The Ownership column contains decimal values that represent percentage of ownership. The sum of all the values in the Ownership column for a single DimAccount member is 100%. You create the following measures: - Ownership - Amount You need to ensure that when the Amount measure is calculated against the DimCustomer dimension, the weighted value is calculated based on the Ownership measure. What should you do?
Exhibit
Options
- ASet the MeasureExpression property of the Amount measure to [Amount]*[Ownership].
- BSet the FormatString property of the Amount measure to [Amount]*[Ownership].
- CSet the MeasureExpression property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
- DSet the FormatString property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
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.