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.
Explanation: