In aggregating trade volumes for a data mart, why might pre-computed summary tables conceptually outperform on-the-fly calculations during peak query loads?

Question

Computer Science · Data Warehousing

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

To reduce computational overhead by storing frequent aggregates

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

The 'Drain of Wealth' theory was propounded by which Indian nationalist leader?

Which event is considered the turning point in Mahatma Gandhi's leadership in the Indian independence movement?

Which African leader is known for his non-violent opposition to colonial rule?

Answer 1

To allow unlimited drill-down without hierarchies

Answer 2

To enforce normalization in summary structures

Answer 3

To reduce computational overhead by storing frequent aggregates

Answer 4

To increase data redundancy across all levels

Related Practice Questions