The @active data warehouse architecture includes which of the following? At least one data mart Data that can extracted from numerous internal and external sources All of these Near real-time updates TRUE ANSWER : ? YOUR ANSWER : ?
Data transformation includes which of the following? Separating data from one source into various sources of data A process to change data from a summary level to a detailed level Joining data from one source into various sources of data A process to change data from a detailed level to a summary level TRUE ANSWER : ? YOUR ANSWER : ?
Transient data is which of the following? Data in which changes to existing records cause the previous version of the records to be eliminated Data in which changes to existing records do not cause the previous version of the records to be eliminated Data that are never altered or deleted once they have been added Data that are never deleted once they have been added TRUE ANSWER : ? YOUR ANSWER : ?
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented. True False TRUE ANSWER : ? YOUR ANSWER : ?
A multifield transformation does which of the following? Converts data from one field into multiple fields Converts data from multiple fields into one field All of these Converts data from multiple fields into multiple fields TRUE ANSWER : ? YOUR ANSWER : ?
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW. False True TRUE ANSWER : ? YOUR ANSWER : ?
Data in operational systems are typically fragmented and inconsistent. False True TRUE ANSWER : ? YOUR ANSWER : ?
Both status data and event data can be stored in a database. False True TRUE ANSWER : ? YOUR ANSWER : ?
Data scrubbing is which of the following? A process to load the data in the data warehouse and to create the necessary indexes A process to upgrade the quality of data after it is moved into a data warehouse A process to reject data from the data warehouse and to create the necessary indexes A process to upgrade the quality of data before it is moved into a data warehouse TRUE ANSWER : ? YOUR ANSWER : ?
A goal of data mining includes which of the following? To explain some observed event or condition To confirm that data exists To analyze data for expected relationships To create a new data warehouse TRUE ANSWER : ? YOUR ANSWER : ?