Database - Data Warehousing
Database - Data Warehousing
11. The load and index is which of the following?
- 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
- 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
12. The extract process is which of the following?
- Capturing all of the data contained in various operational systems
- Capturing a subset of the data contained in various operational systems
- Capturing all of the data contained in various decision support systems
- Capturing a subset of the data contained in various decision support systems
13. A star schema has what type of relationship between a dimension and fact table?
- Many-to-many
- One-to-one
- One-to-many
- All of the above.
14. 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
15. A multifield transformation does which of the following?
- Converts data from one field into multiple fields
- Converts data from multiple fields into one field
- Converts data from multiple fields into multiple fields
- All of the above