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.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *