Data Mining and Data Warehouse MCQs | Page - 3
Dear candidates you will find MCQ questions of Data Mining and Data Warehouse here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Q. The source of all data warehouse data is the____________.
✅ Correct Answer: (A)
operational environment.
Q. Data warehouse contains_____________data that is never found in the operational environment.
✅ Correct Answer: (C)
summary.
Q. Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed in the conversion process.
✅ Correct Answer: (D)
80 percent.
Q. Detail data in single fact table is otherwise known as__________.
✅ Correct Answer: (C)
atomic data.
Q. _______test is used in an online transactional processing environment.
✅ Correct Answer: (D)
acid.
Q. ___________ is a good alternative to the star schema.
✅ Correct Answer: (C)
fact constellation.
Q. The biggest drawback of the level indicator in the classic star-schema is that it limits_________.
✅ Correct Answer: (C)
flexibility.
Q. A data warehouse is _____________.
✅ Correct Answer: (C)
organized around important subject areas.
Jump to