5370 Quiz 9

An event is a database action that results from a transaction.

True

An operational data store is typically a relational database and normalized, but it is tuned for decision-making applications.

True

Data reconciliation occurs in two stages, an initial load and subsequent updates.

True

ETL is short for Extract, Transform, Load.

True

For performance reasons, it may be necessary to define more than one fact table for a star schema.

True

Grain and duration have a direct impact on the size of fact tables.

True

Joining is often complicated by problems such as errors in source data.

True

Scalable technology is often critical to a data mart.

True

The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.

True

All of the following are some beneficial applications for real-time data warehousing EXCEPT:

data entry.

A data mart is a(n):

data warehouse that is limited in scope.

A star schema contains both fact and ________ tables.

dimension

Grain and duration have a direct impact on the size of ________ tables.

fact

The analysis of data or information to support decision making is called:

informational processing.

An operational data store (ODS) is a(n):

integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users.

Conformed dimensions allow users to do the following:

query across fact tables with consistency.

Informational systems are designed for all of the following EXCEPT:

running a business in real time.

Transient data are never changed.

False

Factless fact tables may apply when:

we are deleting correlated data.

Operational and informational systems are generally separated because of which of the following factors?

A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.

Which of the following factors drive the need for data warehousing?

Businesses need an integrated view of company information.

A fact table holds descriptive data about the business.

False

A separate data warehouse causes more contention for resources in an organization.

False

Data federation consolidates all data into one database.

False

Independent data marts do not generally lead to redundant data and efforts.

False

Logical data marts are physically separate databases from the enterprise data warehouse.

False

NoSQL is a great technology for storing well-structured data.

False

Operational metadata are derived from the enterprise data model.

False

The development of the relational data model did not contribute to the emergence of data warehousing.

False

________ technologies are allowing more opportunities for real-time data warehouses.

RFID