Exit 70-466 Implementing Data Models and Reports with Microsoft SQL Server
Question 4 of 5
0% complete
Q4 Single choice

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design.

The Organization dimension includes a parent-child hierarchy named Organizations. The dimension includes the following dimension attributes:

Organization, which is a key attribute Organizations, which defines the parent-child hierarchy Currency Code, which is a regular attribute PercentageOfOwnership, which is a regular attribute

When users browse the dimension, four hierarchies are visible to them.

You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users.

What should you do?

  • A

    Set the AttributeHierarchyVisible property to False for the Organization and PercentageOfOwnership attributes.

  • B

    Set the AttributeHierarchyEnabled property to False for the Organization and PercentageOfOwnership attributes.

  • C

    Delete the Organization and the PercentageOfOwnership attributes.

  • D

    Set the AttributHierarchyDisplayFolder property to Null for the Organization and PercentageOfOwnership attributes.

Previous Next