Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW. True False TRUE ANSWER : ? YOUR ANSWER : ?
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem. True False TRUE ANSWER : ? YOUR ANSWER : ?
Both status data and event data can be stored in a database. True False TRUE ANSWER : ? YOUR ANSWER : ?
Reconciled data is which of the following? Current data intended to be the single source for all decision support systems. Data stored in the various operational systems throughout the organization. Data stored in one operational system in the organization. Data that has been selected and formatted for end-user support applications. TRUE ANSWER : ? YOUR ANSWER : ?
Joining is the process of partitioning data according to predefined criteria. True False TRUE ANSWER : ? YOUR ANSWER : ?
An operational system is which of the following? A system that is used to run the business in real time and is based on current data. A system that is used to run the business in real time and is based on historical data. A system that is used to support decision making and is based on historical data. A system that is used to support decision making and is based on current data. TRUE ANSWER : ? YOUR ANSWER : ?
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented. False True TRUE ANSWER : ? YOUR ANSWER : ?
The role of the ETL process is to identify erroneous data and to fix them. False True TRUE ANSWER : ? YOUR ANSWER : ?
The generic two-level data warehouse architecture includes which of the following? At least one data mart All of these Data that can extracted from numerous internal and external sources Near real-time updates TRUE ANSWER : ? YOUR ANSWER : ?
The @active data warehouse architecture includes which of the following? Data that can extracted from numerous internal and external sources All of these At least one data mart Near real-time updates TRUE ANSWER : ? YOUR ANSWER : ?