Chapter 2

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are

subject oriented and nonvolatile

Data Warehouses typically store only a certain amount of old data. What is the most common length of time that a data warehouse keeps in its storage?

15 months

Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure.

False

Data warehouses are subsets of data marts.

False

OLTP databases are optimized for output (querying/asking questions of the data) and data warehouses are optimized for input (getting new or updated data into the database).

False

OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.

False

Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.

False

Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks

False

Active data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is

Speed of data transfer

One way an operational data store differs from a data warehouse is the recency of their data.

True