Data Warehouse MCQ

Data Warehouse MCQ Questions

• 1. The data Warehouse is ...............
• 2. The important aspect of the data warehouse environment is that data found within the data warehouse is .............
• 3. The time horizon in Data warehouse is usually ...............
• 4. ................ describes the data contained in the data warehouse.
• 5. Which of the following predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions?
• 6. ................ is the heart of the warehouse.
• 7. ................ is the specialized data warehouse database.
• 8. Which of the following defines the structure of the data held in operational databases and used byoperational applications?
• 9. Which of the following consists of information in the enterprise that is not in classical form?
• 10. Data can be updated in _____environment.
• 11. The source of all data warehouse data is the ....................
• 12. Data warehouse contains ............. data that is never found in the operational environment.
• 13. Bill Inmon has estimated___________of the time required to build a data warehouse, is consumedin the conversion process.
• 14. The generic two-level data warehouse architecture includes ................
• 15. The active data warehouse architecture includes ..................
• 16. Data scrubbing is .............
• 17. The load and index is .......................
• 18. The most common source of change data in refreshing a data warehouse is ...............
• 19. .................... are responsible for running queries and reports against data warehouse tables.
• 20. The main organizational justification for implementing a data warehouse is to provide ................