Data Warehouse MCQ

  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 ................
Data Warehouse MCQ

Practice Data Warehouse MCQ Quiz & Online Test

We have listed below the best Data Warehouse MCQ Questions, that check your basic knowledge of Data Warehousing. This Data Warehouse MCQ Test contains 20+ Data Warehouse Multiple Choice Questions. So, practice these questions to check your final preparation for Data Warehouse MCQ Interviews, Exams & Placement drives. apart from this, you can also download below the Data Warehouse MCQ PDF, completely free.

  • Read only system
  • Write only system
  • Both Read & Write System
  • None of the above
View Answer
  • 3-4years
  • 5-6 years
  • 5-10 years
  • None of the above
View Answer
  • Metadata
  • Relational data
  • Informational data
  • None of the above
View Answer
  • Data mart database servers
  • Relational data base servers
  • Data warehouse database servers
  • All of the above
View Answer
  • User-level metadata.
  • Operational metadata.
  • Operational metadata.
  • Data warehouse metadata.
View Answer
  • Data mining
  • Mushy metadata.
  • Differential metadata.
  • None of the above
View Answer
  • Operational
  • Data mining
  • Informational
  • None of the above
View Answer
  • Formal environment
  • Informal environment
  • Operational environment
  • None of the above
View Answer
  • At least one data mart.
  • Far real-time updates.
  • Near real-time updates.
  • None of the above
View Answer
  • At least one data mart.
  • Near real-time updates.
  • Data that can extracted from numerous internal and external sources
  • All of the above
  • A process to upgrade the quality of data after it is moved into a data warehouse
  • A process to upgrade the quality of data before it is moved into a data warehouse
  • A process to reject data from the data warehouse and to create the necessary indexes
  • None of the above
View Answer
  • A process to upgrade the quality of data after it is moved into a data warehouse
  • A process to upgrade the quality of data before it is moved into a data warehouse
  • A process to load the data in the data warehouse and to create the necessary indexes
  • None of the above
View Answer
  • Logged change data
  • Snapshot change data
  • Queryable change data
  • None of the above
View Answer
  • Access to data
  • Decision support
  • Storing large volume of data
  • Cheaper ways of handling transportation.
View Answer