Multiple choice technology operating systems

Which statement(s) is/are true related to Navigational attributes vs. Dimensional attributes?

  1. Dimensional attributes have a performance advantage over Navigational attributes for queries

  2. Change history will be available if an attribute is defined as navigational

  3. History of changes is available if an attribute is included as a characteristic in the cube

  4. All of the above
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

Dimensional attributes outperform navigational attributes in query execution because they're physically part of the star schema. Navigational attributes are joined at query time, adding overhead. Change tracking is available for characteristics stored in the cube but not for navigational attributes.

Keep practicing — related questions