A data warehouse for algorithmic trading backtesting uses surrogate keys in dimension tables. Conceptually, why are these keys preferable to natural keys when dealing with evolving market entity identifiers?

Question

Computer Science · Data Warehousing

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

To insulate the data warehouse from changes in source system operational keys

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Data Warehousing?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · Data Warehousing

Which of the following organizations was instrumental in advocating for the abolition of Sati in India?

Who was the first President of independent India?

Who among the following was the founder of the 'Gadar Party'?

Answer 1

To allow direct use of business-meaningful values for joins

Answer 2

To simplify ETL by skipping key generation steps

Answer 3

To insulate the data warehouse from changes in source system operational keys

Answer 4

To enable automatic indexing on all natural attributes

Related Practice Questions