Curioustab

Home » Database » Data Warehousing

A data mart is designed to optimize the performance for well-defined and predicable uses.

True

Correct Answer: True

← Previous Question Next Question→

More Questions from Data Warehousing

Data in operational systems are typically fragmented and inconsistent.
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Data in the data warehouse are loaded and refreshed from operational systems.
Every key used to join the fact table with a dimensional table should be a surrogate key.
Both status data and event data can be stored in a database.
Joining is the process of partitioning data according to predefined criteria.
Most operational systems are based on the use of transient data.
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion