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)Both B and C
E)All of the above

Question

Quizplus · Accepted Answer

A data warehouse database differs from an operational database because data warehouse data are often stored in a dimensional database, where data is organized into dimensions and measures. Operational databases, on the other hand, are organized into tables with a primary key and are optimized for transaction processing. Choice A is incorrect because data warehouse data can be stored in tables within a dimensional database. Choice B is incorrect because both data warehouse and operational databases have metadata.

A Data Warehouse Database Differs from an Operational Database Because