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