Exam 9: Data Warehousing and Data Integration

Periodic data are data that are never physically altered or deleted once they have been added to the store.

When would it be appropriate to use factless fact tables?

Event-driven propagation:

When determining the size of a fact table, estimating the number of possible values for each dimension associated with the fact table is equivalent to:

Discuss the four key terms (subject-oriented, integrated, time-variant, and nonupdateable) related to data warehousing.

Update mode is used to create a data warehouse.

What is data mining, and what are its goals?

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

After the extract, transform, and load is done on data, the data warehouse is never fully normalized.

A star schema contains both fact and ________ tables.

Discuss the history of data warehousing.

ETL is short for Extract, Transform, Load.

The key discovery that triggered the development of data warehouses was:

Refresh mode is an approach to filling the data warehouse that employs bulk rewriting of the target data at periodic intervals.

The data reconciliation process is responsible for transforming operational data to reconciled data.

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.

Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.

Explain the four basic steps to build an independent data mart.

Discuss data governance and what needs to be included in a data governance program.