Q. An operational system is _____________.
✅ Correct Answer: (B)
used to run the business in real time and is based on current data.
Data Mining and Data Warehouse MCQs | Page - 4
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 generic two-level data warehouse architecture includes __________.
✅ Correct Answer: (B)
data that can extracted from numerous internal and external sources.
Q. The active data warehouse architecture includes __________
✅ Correct Answer: (D)
all of the above.
Q. Reconciled data is ___________.
✅ Correct Answer: (B)
current data intended to be the single source for all decision support systems.
Q. The extract process is ______.
✅ Correct Answer: (B)
capturing a subset of the data contained in various operational systems.
Q. Data scrubbing is _____________.
✅ Correct Answer: (D)
a process to upgrade the quality of data before it is moved into a data warehouse
Q. The load and index is ______________.
✅ Correct Answer: (B)
a process to load the data in the data warehouse and to create the necessary indexes.
Q. Data transformation includes __________.
✅ Correct Answer: (A)
a process to change data from a detailed level to a summary level.
Q. ____________ is called a multifield transformation.
✅ Correct Answer: (A)
converting data from one field into multiple fields.
Q. The type of relationship in star schema is __________________.
✅ Correct Answer: (C)
one-to-many.
Jump to