Most operational systems are based on the use of transient data. False True TRUE ANSWER : ? YOUR ANSWER : ?
A star schema has what type of relationship between a dimension and fact table? Many-to-many One-to-many One-to-one All of these TRUE ANSWER : ? YOUR ANSWER : ?
Every key used to join the fact table with a dimensional table should be a surrogate key. True False TRUE ANSWER : ? YOUR ANSWER : ?
Transient data is which of the following? Data in which changes to existing records do not cause the previous version of the records to be eliminated Data in which changes to existing records cause the previous version of the records to be eliminated Data that are never deleted once they have been added Data that are never altered or deleted once they have been added TRUE ANSWER : ? YOUR ANSWER : ?
A data mart is designed to optimize the performance for well-defined and predicable uses. False True 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 : ?
Periodic data are data that are physically altered once added to the store. True False TRUE ANSWER : ? YOUR ANSWER : ?
The role of the ETL process is to identify erroneous data and to fix them. True False TRUE ANSWER : ? YOUR ANSWER : ?
Data scrubbing is which of the following? A process to upgrade the quality of data after it is moved into a data warehouse A process to upgrade the quality of data before 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 load the data in the data warehouse and to create the necessary indexes TRUE ANSWER : ? YOUR ANSWER : ?