70-448 · Question #147
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…
The correct answer is C. The AttributeHierarchyEnabled property of the Amount attribute should be set to False to accomplish. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server 2008 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?
Options
- AThe MembersWithData property of the Amount attribute should be set to False to accomplish this task.
- BThe IsAggregatable property of the Amount attribute should be set to False to accomplish this task.
- CThe AttributeHierarchyEnabled property of the Amount attribute should be set to False to accomplish
- DThe MembersWithData property of the Amount attribute should be set to NonLeafDataHidden to
- EThe GroupingBehavior property of the Amount attribute should be set to DiscourageGrouping to
How the community answered
(37 responses)- A3% (1)
- B8% (3)
- C81% (30)
- D3% (1)
- E5% (2)
Community Discussion
No community discussion yet for this question.