Which of the Following Is Not True of a Hierarchy

question 57

Multiple Choice

Which of the following is not true of a hierarchy in an Excel Data Model?

• A)Only one hierarchy per table is allowed.For example,it wouldn't be possible to create the hierarchy Continent,Country,Region,City and the hierarchy Continent,Country,State/Province,City,Zip based on a Geography table.
• B)A hierarchy must be created in the Power Pivot window.
• C)A hierarchy is often aided by DAX's RELATED function,so that fields from related tables can be brought into a single table and used in building the hierarchy.
• D)A hierarchy's main use is to allow users to drill down through the hierarchy in a pivot table.

---

Definitions:

Implemented

Executed or carried out a plan, decision, or method, making it active or effective.

Inoculate

in a non-medical context, means to protect or prepare someone in advance against adverse conditions or criticism.

Resilient

The ability to quickly recover from difficulties; toughness and adaptability in the face of adversity.

Vulnerable

Exposed to the possibility of being attacked or harmed, either physically or emotionally.