Which process pre-aggregates data to speed up query performance in a data warehouse?
- Data Cleansing
- Data Compression
- Data Modeling
- ETL (Extract, Transform, Load)
The process that pre-aggregates data to enhance query performance in a data warehouse is ETL (Extract, Transform, Load). During ETL, data is transformed and summarized, allowing queries to access pre-computed aggregations, which significantly improves query response times.
Loading...
Related Quiz
- In the context of data warehousing evolution, the shift from batch processing to real-time processing was a significant step towards _______.
- A retail company wants to analyze the past 10 years of transaction data to forecast future sales. They are considering big data solutions due to the volume of data. Which storage and processing model would be most suitable?
- Which BI functionality allows users to ask and answer their own questions without involving IT to create a new report?
- A business analyst is trying to analyze monthly sales data for the past three years. She wants to view sales by year, quarter, month, and day. What concept will aid her in viewing data at these different granularities?
- In BI reporting, what type of visualization would best represent the distribution of sales over a year?