Computer Science · Data Warehousing
In a data warehousing environment handling financial transaction logs from multiple stock exchanges, which approach best ensures that historical data remains consistent while allowing for efficient querying of aggregated sales volumes over time?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1Storing all data in a flat file structure for simplicity
- 2Applying real-time OLTP processing to update aggregates dynamically
- 3Using a star schema with denormalized dimension tables to speed up joins✓
- 4Implementing a fully normalized relational model to minimize redundancy
Correct answer
Using a star schema with denormalized dimension tables to speed up joins
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Data Warehousing MCQs →Want more practice questions on Data Warehousing?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Data Warehousing