Exam 70-768 topic 1 question 25 discussion

Actual exam question from Microsoft's 70-768

Question #: 25
Topic #: 1

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:
✑ Stock Item Key
✑ WWI Stock Item ID
✑ Stock Item
✑ Color
✑ Selling Package
✑ Buying Package
✑ Brand
✑ Size
✑ Lead Time Days
✑ Quantity Per Outer
✑ Is Chiller Stock
✑ Barcode
✑ Tax Rate
✑ Unit Price
✑ Recommended Retail Price
✑ Typical Weight Per Unit

Photo -

✑ Valid From
✑ Valid To
✑ Lineages Key
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.

Show Suggested Answer

Suggested Answer: A 🗳️
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

by DudeHere at Jan. 16, 2021, 10 a.m.

Comments

Submit Cancel

DudeHere

4 years, 5 months ago

...the value of the AttributeHierarchyVisible property determines whether the attribute hierarchy is visible independent of its use in a user-defined hierarchy. https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms166717(v=sql.110)?redirectedfrom=MSDN

upvoted 1 times

...