PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the Amount measure aggregates c…

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.)

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply