You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008 Analysis Services (SSAS) solution.
To meet the business development, a dimension named DimSales is created with an Amount attribute, and then it is used in a cube structure.
Now you are assigned a task to make sure that aggregations have no relationship with the Amount attribute. What action should you perform to accomplish this task?
A.
The MembersWithData property of the Amount attribute should be set to False to accomplish this task.
B.
The IsAggregatable property of the Amount attribute should be set to False to accomplish this task.
C.
The AttributeHierarchyEnabled property of the Amount attribute should be set to False to accomplish this task.
D.
The MembersWithData property of the Amount attribute should be set to NonLeafDataHidden to accomplish this task
E.
The GroupingBehavior property of the Amount attribute should be set to DiscourageGrouping to accomplish this task.