70-466 Free Dumps Study Materials
Question 8: You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum
aggregation function is used for the Amount measure. The cube includes a dimension named Account
and the dimension's Type property is set to Accounts. The Account dimension includes an account
type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account type
classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Develop a .NET application that uses Analysis Management Objects (AMO) to change the existing
AggregateFunction property value of the Amount measure to FirstNonEmpty and then use the
application.
B. Develop a .NET application that uses Analysis Management Objects (AMO) to change the existing
AggregateFunction property value of the Amount measure to ByAccount and then use the
application.
C. Use SQL Server Data Tools to change the AggregateFunction property value of the Amount
measure to ByAccount.
D. Add the ByAccount attribute to the account dimension.
Correct Answer: C