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