Data Warehousing MCQ Questions And Answers

Data Warehousing MCQ Questions And Answers

21. Data warehouse architecture is based on ________

  1. dbms
  2. sybase
  3. rdbms
  4. sqlserver

Answer : C
Explanation: Data warehouse architecture is based on rdbms.

22. How many approaches are there in data warehousing to integrate heterogeneous databases?

  1. 2
  2. 5
  3. 4
  4. 3

Answer : A
Explanation: 2 approaches are there in data warehousing to integrate heterogeneous databases.

23. The term Data Warehouse was first coined by?

  1. Roger Mougalas
  2. Herbert Simon
  3. Bill Inmon
  4. Arthur Samuel

Answer : C
Explanation: The term Data Warehouse was first coined by Bill Inmon.

24. The generic two-level data warehouse architecture includes which of the following?

  1. Near real-time updates
  2. Data that can extracted from numerous internal and external sources
  3. At least one data mart
  4. None of the mentioned

Answer : B
Explanation: The generic two-level data warehouse architecture includes data that can extracted from numerous internal and external sources.

25. In Which year, Data Warehouse was first coined?

  1. 1990
  2. 1991
  3. 1989
  4. 1992

Answer : A
Explanation: Data Warehouse was first coined in 1990.

Data Science MCQ Questions And Answers

26. ________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.

  1. Data mining
  2. Data warehousing
  3. Web mining
  4. Text mining

Answer : B
Explanation: Data warehousing is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.

27. Reconciled data is which of the following?

  1. Current data intended to be the single source for all decision support systems
  2. Data stored in the various operational systems throughout the organization
  3. Data stored in one operational system in the organization
  4. Data that has been selected and formatted for end-user support application

Answer : A
Explanation: Reconciled data is in which current data intended to be the single source for all decision support systems.

28.  Describes the data contained in the data warehouse.

  1. Relational data
  2. Metadata
  3. Informational data
  4. None of the mentioned

Answer : B
Explanation: Metadata Describes the data contained in the data warehouse.

29. Most NoSQL databases support automatic ________ meaning that you get high availability and disaster recovery.

  1. Scalability
  2. Processing
  3. Replication
  4. All of the above

Answer : C
Explanation: Most NoSQL databases support automatic replication meaning that you get high availability and disaster recovery.

30. The full form of OLAP is

  1. Online Advanced Processing
  2. Online Advanced Preparation
  3. Online Analytical Performance
  4. Online Analytical Processing

Answer : D
Explanation: The full form of OLAP is Online Analytical Processing.

Pages: 1 2 3

Leave a Reply