Top 350+ Solved Data Mining and Data Warehouse MCQ Questions Answer
Q. Which of the following is not a old detail storage medium?
a. phot optical storage.
b. raid.
c. microfinche.
d. pen drive.
Q. The data from the operational environment enter _______ of data warehouse.
a. current detail dat
b. older detail data.
c. lightly summarized data.
d. highly summarized data.
Q. The data in current detail level resides till ________ event occurs.
a. purge.
b. summarization.
c. archieved.
d. all of the above.
Q. The dimension tables describe the _________.
a. entities.
b. facts.
c. keys.
d. units of measures.
Q. The granularity of the fact is the _____ of detail at which it is recorded.
a. transformation.
b. summarization.
c. level.
d. transformation and summarization.
Q. Which of the following is not a primary grain in analytical modeling?
a. transaction.
b. periodic snapshot.
c. accumulating snapshot.
d. all of the above.
Q. Granularity is determined by ______.
a. number of parts to a key.
b. granularity of those parts.
c. both a and b.
d. none of the above.
Q. ___________ of data means that the attributes within a given entity are fully dependent on the entireprimary key of the entity.
a. additivity.
b. granularity.
c. functional dependency.
d. dimensionality.
Q. A fact is said to be fully additive if ___________.
a. it is additive over every dimension of its dimensionality.
b. additive over atleast one but not all of the dimensions.
c. not additive over any dimension.
d. none of the above.
Q. A fact is said to be partially additive if ___________.
a. it is additive over every dimension of its dimensionality.
b. additive over atleast one but not all of the dimensions.
c. not additive over any dimension.
d. none of the above.
Q. A fact is said to be non-additive if ___________.
a. it is additive over every dimension of its dimensionality.
b. additive over atleast one but not all of the dimensions.
c. not additive over any dimension.
d. none of the above.
Q. Non-additive measures can often combined with additive measures to create new _________.
a. additive measures.
b. non-additive measures.
c. partially additive.
d. all of the above.
Q. A fact representing cumulative sales units over a day at a store for a product is a _________.
a. additive fact.
b. fully additive fact.
c. partially additive fact.
d. non-additive fact.
Q. ____________ of data means that the attributes within a given entity are fully dependent on the entireprimary key of the entity.
a. additivity.
b. granularity.
c. functional dependency.
d. dependency.
Q. Which of the following is the other name of Data mining?
a. exploratory data analysis.
b. data driven discovery.
c. deductive learning.
d. all of the above.