Data Warehousing problems
- 1. A star schema has what type of relationship between a dimension and fact table?
Options- A. Many-to-many
- B. One-to-one
- C. One-to-many
- D. All of the above. Discuss
Correct Answer: One-to-many
- 2. Transient data is which of the following?
Options- A. Data in which changes to existing records cause the previous version of the records to be eliminated
- B. Data in which changes to existing records do not cause the previous version of the records to be eliminated
- C. Data that are never altered or deleted once they have been added
- D. Data that are never deleted once they have been added Discuss
Correct Answer: Data in which changes to existing records cause the previous version of the records to be eliminated
- 3. Reconciled data is which of the following?
Options- A. Data stored in the various operational systems throughout the organization.
- B. Current data intended to be the single source for all decision support systems.
- C. Data stored in one operational system in the organization.
- D. Data that has been selected and formatted for end-user support applications. Discuss
Correct Answer: Current data intended to be the single source for all decision support systems.
- 4. The load and index is which of the following?
Options- A. A process to reject data from the data warehouse and to create the necessary indexes
- B. A process to load the data in the data warehouse and to create the necessary indexes
- C. A process to upgrade the quality of data after it is moved into a data warehouse
- D. A process to upgrade the quality of data before it is moved into a data warehouse Discuss
Correct Answer: A process to load the data in the data warehouse and to create the necessary indexes
- 5. A multifield transformation does which of the following?
Options- A. Converts data from one field into multiple fields
- B. Converts data from multiple fields into one field
- C. Converts data from multiple fields into multiple fields
- D. All of the above Discuss
Correct Answer: All of the above
- 6. The role of the ETL process is to identify erroneous data and to fix them.
Options- A. True
- B. False Discuss
Correct Answer: False
- 7. A data mart is designed to optimize the performance for well-defined and predicable uses.
Options- A. True
- B. False Discuss
Correct Answer: True
- 8. Data in operational systems are typically fragmented and inconsistent.
Options- A. True
- B. False Discuss
Correct Answer: True
- 9. Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Options- A. True
- B. False Discuss
Correct Answer: False
- 10. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Options- A. True
- B. False Discuss
Correct Answer: True
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.