Multiple choice technology

Why does an application developer create multiple hierarchies in a dimension

  1. To increase the number of dimensions and empty cells in a cube.

  2. To increase the sparsity of the dimensions and empty cells in a cube.

  3. To reduce the number of dimensions and empty cells in a cube.

  4. To reduce the density of the dimensions and string cells in a cube.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Creating multiple hierarchies within a single dimension reduces the total number of dimensions needed in a cube, which consequently reduces the number of empty cells. Using separate dimensions for each hierarchy would dramatically increase sparsity.

Keep practicing — related questions