Data warehousing
Advances in computer hardware, particularly the emergence of affordable mass storage and parallel computer architectures, was one of the key advances that led to the emergence of data warehousing.
True
A dependent data mart is filled from the enterprise data warehouse and its reconciled data.
T
An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.
T
An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.
T
An event is a database action that results from a transaction.
T
An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.
T
A data mart is a data warehouse that contains data that can be used across the entire organization.
F
A fact table holds descriptive data about the business.
F
A separate data warehouse causes more contention for resources in an organization. Answer: FALSE
F
Independent data marts do not generally lead to redundant data and efforts.
F
Logical data marts are physically separate databases from the enterprise data warehouse.
F
Operational metadata are derived from the enterprise data model.
F
Reconciled data are data that have been selected, formatted, and aggregated for end-user decision support applications.
F
The development of the relational data model did not contribute to the emergence of data warehousing.
F
The representation of data in a graphical format is called data mining.
F
The status of data is the representation of the data after an event has occurred.
F
Transient data are never changed.
F
When multiple systems in an organization are synchronized, the need for data warehousing increases.
F
A corporate information factory (CIF) is a comprehensive view of organizational data in support of all user data requirements.
T
Drill-down involves analyzing a given set of data at a finer level of detail.
T
Informational systems are designed to support decision making based on historical point-in- time and prediction data.
T
Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.
T
Periodic data are data that are never physically altered or deleted once they have been added to the store.
T
Rule discovery searches for patterns and correlations in large data sets.
T
Scalable technology is critical to a data mart.
T
The enterprise data model controls the phased evolution of the data warehouse.
T
The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.
T