Intermediate
Database Management Systems
Q62 / 100
What is data warehousing?
Correct! Well done.
Incorrect.
The correct answer is B) A system for collecting, storing, and analyzing large volumes of historical data from multiple sources for business intelligence and reporting
B
Correct Answer
A system for collecting, storing, and analyzing large volumes of historical data from multiple sources for business intelligence and reporting
Explanation
Data warehouses (Snowflake, Redshift, BigQuery) are optimized for OLAP queries with star/snowflake schemas, columnar storage, and MPP (massively parallel processing) for fast aggregations.
Progress
62/100