You are developing a SQL Server Analysis Services (SSAS) cube. You must create a four-level hierarchy for the employee dimension. Each level must be associated with an attribute in the employee dimens

A parent-child hierarchy is used for recursive self-referencing relationships (like employee-manager), not for fixed-level hierarchies with unequal depth.

Sparse is not a standard SSAS hierarchy type - sparsity refers to empty cells in the cube data space, not to missing levels in a dimension hierarchy.

A ragged hierarchy is specifically designed for dimensions where members do not have a uniform depth across all branches - exactly the scenario where one third of members have only three of four levels populated. SSAS provides the HideMemberIf property on ragged hierarchies to suppress logically missing members so they do not appear in reporting tools.

A balanced hierarchy requires that all members at every branch share the same depth, which contradicts the scenario where one third of members only have three levels.