Which change should you make to the properties for the Stock Item Key and Photo attributes?

You are building a Microsoft SQL Server Analysis Services multidimensional model over a SQL Server database. In a cube named OrderAnalysis, there is a standard cube dimension named Stock Item.

This dimension has the following attributes:

Users report that the attributes Stock Item Key and Photo are distracting and are not providing any value. They have asked for the attributes to be removed. However, these attributes are needed by other cubes.

You need to hide the specified attributes from the end users of the OrderAnalysis cube. You do not want to change the structure of the dimension.

Which change should you make to the properties for the Stock Item Key and Photo attributes?
A . Set the AttributeHierarchyVisible property to False.
B . Set the AttributeHierarchyEnabledproperty to False.
C . Set the AttributeVisibility property to Hidden.
D . Set the Usage property to Regular.
E . Set the AttributeHierarchyDisplayFolder property to Hidden.

View Answer

Answer: A

Explanation:

The value of the AttributeHierarchyEnabled property determines whether an attribute hierarchy is created. If this property is set to False, the attribute hierarchy is not created and the attribute cannot be used as a level in a user hierarchy; the attribute hierarchy exists as a member property only. However, a disabled attribute hierarchy can still be used to order the members of another attribute. If the value of the AttributeHierarchyEnabled property is set to True, the value of the AttributeHierarchyVisible property determines whether the attribute hierarchy is visible independent of its use in a user-defined hierarchy.

References:https://technet.microsoft.com/en-us/library/ms166717(v=sql.110).aspx