Turban05_tif - Chapter 5 Data Warehousing True-False...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 5 Data Warehousing True-False Questions 1. A real-time, enterprise-level data warehouse combined with a strategy for its use in decision support can leverage data to provide massive financial benefits for an organization. Answer : True Difficulty : Easy Page Reference : 209 2. A data warehouse differs from an operational database in that most data warehouses have a product orientation and are tuned to handle transactions that update the database. Answer : False Difficulty : Easy Page Reference : 209 3. A data warehouse uses either a relational, network or multidimensional structure. Answer : False Difficulty : Easy Page Reference : 210 4. Once the data are entered into the data warehouse, users cannot change or update the data. Answer : True Difficulty : Medium Page Reference : 210 5. An independent data mart ensures that the end user is viewing the same version of the data that are accessed by all other data warehouse users. Answer : False Difficulty : Moderate Page Reference : 210 6. Operational data store is used for the medium- and long-term decisions associated with the enterprise data warehouse (EDW). Answer : False Difficulty : Moderate Page Reference : 211 7. The data for an operational data store are created from oper marts. Answer : False Difficulty : Moderate Page Reference : 211 8. Metadata can generally be defined in terms of usage and pattern. Answer : True Difficulty : Moderate Page Reference : 211 9. There are five levels of metadata management maturity that can be used to describe where an organization is in terms of how and how well it utilizes its metadata. Answer : True Difficulty : Medium Page Reference : 212 51
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
10. Data warehouses contain vast amounts of internal data but are limited because they do not contain external data. Answer : False Difficulty : Moderate Page Reference : 213 11. The two most common data warehouse architectures are three tiered and four tiered. Answer : False Difficulty : Easy Page Reference : 214 12. In a three-tier architect for data warehousing, data from the warehouse are processed once and deposited in an additional multidimensional database, organized for easy multidimensional analysis and presentation, or replicated in data marts. Answer : False Difficulty : Moderate Page Reference : 214 13. Page loading speed is an important consideration in designing Web-based applications. Answer : True Difficulty : Easy Page Reference : 217 14. A centralized data warehouse is similar to the hub-and-spoke architecture except that there are no independent data marts. Answer : False Difficulty : Moderate Page Reference : 220 15. The centralized data warehouse helps to simplify data management and administration. Answer
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/29/2010 for the course FCIT 100 taught by Professor Dr.adam during the Spring '10 term at Katholieke Universiteit Leuven.

Page1 / 12

Turban05_tif - Chapter 5 Data Warehousing True-False...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online