Multiple choice technology platforms and products

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 because they're materialized in the cube itself, avoiding join operations at query time - A is true. Navigational attributes don't inherently track change history - that requires time-dependent navigational attributes - so B is false. When an attribute is included as a characteristic with time dimensions in the cube, change history becomes available - C is true.

Keep practicing — related questions