Data Mining and Data Warehouse MCQs with answers Page - 10

Here, you will find a collection of MCQ questions on Data Mining and Data Warehouse. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 828.03K Points
Coach

Q. Which of the following is not a old detail storage medium?

  • (A) phot optical storage.
  • (B) raid.
  • (C) microfinche.
  • (D) pen drive.

A

Admin • 828.03K Points
Coach

Q. The data from the operational environment enter _______ of data warehouse.

  • (A) current detail data.
  • (B) older detail data.
  • (C) lightly summarized data.
  • (D) highly summarized data.

A

Admin • 828.03K Points
Coach

Q. The data in current detail level resides till ________ event occurs.

  • (A) purge.
  • (B) summarization.
  • (C) archieved.
  • (D) all of the above.

A

Admin • 828.03K Points
Coach

Q. The dimension tables describe the _________.

  • (A) entities.
  • (B) facts.
  • (C) keys.
  • (D) units of measures.

A

Admin • 828.03K Points
Coach

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.

A

Admin • 828.03K Points
Coach

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.

A

Admin • 828.03K Points
Coach

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.

A

Admin • 828.03K Points
Coach

Q. ___________ of data means that the attributes within a given entity are fully dependent on the entire primary key of the entity.

  • (A) additivity.
  • (B) granularity.
  • (C) functional dependency.
  • (D) dimensionality.

A

Admin • 828.03K Points
Coach

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.

A

Admin • 828.03K Points
Coach

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.

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.