What should you do?

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.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.