Discussion
Home ‣ Database ‣ Data Warehousing Comments
- Question
Data in operational systems are typically fragmented and inconsistent.
Options- A. True
- B. False
- Correct Answer
- True
- 1. A data mart is designed to optimize the performance for well-defined and predicable uses.
Options- A. True
- B. False Discuss
- 2. The role of the ETL process is to identify erroneous data and to fix them.
Options- A. True
- B. False Discuss
- 3. The Windows operating system and Windows applications are event driven.
Options- A. True
- B. False Discuss
- 4. 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
- 5. With an asynchronous system, the requesting system waits for a response in real time.
Options- A. True
- B. False Discuss
- 6. 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
- 7. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Options- A. True
- B. False Discuss
- 8. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Options- A. True
- B. False Discuss
- 9. Data in the data warehouse are loaded and refreshed from operational systems.
Options- A. True
- B. False Discuss
- 10. Every key used to join the fact table with a dimensional table should be a surrogate key.
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: False
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.