A data warehouse database differs from an operational database because ________.
A)data warehouse data are not stored in tables
B)data warehouse databases do not have metadata
C)data warehouse data are often stored in a dimensional database
D)efficiency does not matter in a data warehouse

Question

Quizplus · Accepted Answer

Data warehouse data are often stored in a dimensional database, which is designed to support analytical queries and reporting. Operational databases, on the other hand, are designed to support day-to-day transactional processes and are typically stored in a relational database. Option A is incorrect because data warehouse data are often stored in tables. Option B is incorrect because data warehouse databases do have metadata. Option D is incorrect because efficiency is still important in a data warehouse, but the focus is on query performance rather than transaction processing speed.

A Data Warehouse Database Differs from an Operational Database Because