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:

Authority Check

The process of verifying that citations in legal documents refer correctly to precedents, statutes, or regulations.

Good Law

Legal principles and precedents that are currently valid, effective, and enforceable under the law.

Relevant Cases

Prior legal cases or precedents that have significance or bearing on the current legal matter being considered.

Specialized Databases

Databases designed to meet specific user needs by focusing on a narrow range of subjects or data types.