Microsoft
70-448 · Question #271
You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution has the following components: - A dimension named DimTime that contains an attribute named Month - A measure group named…
The correct answer is C. Set the AggregationUsage property appropriately. See the full explanation below for the reasoning.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution has the following components:
- A dimension named DimTime that contains an attribute named Month
- A measure group named FactSales that references the DimTime dimension
You need to ensure that the aggregations designed on FactSales always include the Month attribute. What should you do?
Options
- ASet the Usage property appropriately.
- BSet the IsAggregatable property appropriately.
- CSet the AggregationUsage property appropriately.
- DSet the AttributeHierarchyEnabled property appropriately.
How the community answered
(28 responses)- A4% (1)
- B14% (4)
- C75% (21)
- D7% (2)
Community Discussion
No community discussion yet for this question.