Discussion
Home ‣ Database ‣ Data Warehousing Comments
- Question
Every key used to join the fact table with a dimensional table should be a surrogate key.
Options- A. True
- B. False
- Correct Answer
- True
- 1. Data in the data warehouse are loaded and refreshed from operational systems.
Options- A. True
- B. False Discuss
- 2. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Options- A. True
- B. False Discuss
- 3. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Options- A. True
- B. False Discuss
- 4. 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
- 5. Data in operational systems are typically fragmented and inconsistent.
Options- A. True
- B. False Discuss
- 6. Both status data and event data can be stored in a database.
Options- A. True
- B. False Discuss
- 7. Joining is the process of partitioning data according to predefined criteria.
Options- A. True
- B. False Discuss
- 8. Most operational systems are based on the use of transient data.
Options- A. True
- B. False Discuss
- 9. 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
- 10. Independent data marts are often created because an organization focuses on a series of short-term business objectives.
Options- A. True
- B. False Discuss
Data Warehousing problems
Search Results
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
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.