Discussion
Home ‣ Database ‣ Data Warehousing Comments
- Question
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Options- A. True
- B. False
- Correct Answer
- False
- 1. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Options- A. True
- B. False Discuss
- 2. 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
- 3. Data in operational systems are typically fragmented and inconsistent.
Options- A. True
- B. False Discuss
- 4. A data mart is designed to optimize the performance for well-defined and predicable uses.
Options- A. True
- B. False Discuss
- 5. The role of the ETL process is to identify erroneous data and to fix them.
Options- A. True
- B. False Discuss
- 6. Data in the data warehouse are loaded and refreshed from operational systems.
Options- A. True
- B. False Discuss
- 7. Every key used to join the fact table with a dimensional table should be a surrogate key.
Options- A. True
- B. False Discuss
- 8. Both status data and event data can be stored in a database.
Options- A. True
- B. False Discuss
- 9. Joining is the process of partitioning data according to predefined criteria.
Options- A. True
- B. False Discuss
- 10. Most operational systems are based on the use of transient data.
Options- A. True
- B. False Discuss
Data Warehousing problems
Search Results
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.