Data Warehousing Questions

• A snowflake schema is which of the following types of tables?
• Fact tables are which of the following?
• An operational system is which of the following?
• The @active data warehouse architecture includes which of the following?
• A goal of data mining includes which of the following?
• The extract process is which of the following?
• A data warehouse is which of the following?
• Data transformation includes which of the following?
• The generic two-level data warehouse architecture includes which of the following?
• Data scrubbing is which of the following?
• A star schema has what type of relationship between a dimension and fact table?
• Transient data is which of the following?
• Reconciled data is which of the following?
• The load and index is which of the following?
• A multifield transformation does which of the following?
• The role of the ETL process is to identify erroneous data and to fix them.
• A data mart is designed to optimize the performance for well-defined and predicable uses.
• 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.