20th
Feb
Data Warehouse MCQ

Data Warehouse MCQ

  • Admin
  • 20th Feb, 2023
  • 1071 Followers

Data Warehouse MCQ Questions

Practice Data Warehouse MCQ Quiz & Online Test

We have listed below the best Data Warehouse MCQ Questions, that checks your basic knowledge of Data Warehousing. This Data Warehouse MCQ Test contains 20+ Data Warehouse Multiple Choice Questions. So, practice these questions to check your final preparation for Data Warehouse MCQ Interviews, Exams & Placement drives. apart from this, you can also download the Data Warehouse MCQ PDF, completely free.

Data Warehouse MCQ

1) The data Warehouse is ...............

  • A. Read only system
  • B.Write only system
  • C.Both Read & Write System
  • D.None of the above

2) The important aspect of the data warehouse environment is that data found within the data warehouse is .............

  • A. Integrated
  • B.Time-variant
  • C.Subject-oriented
  • D.All of the above

3) The time horizon in Data warehouse is usually ...............

  • A. 3-4years
  • B.5-6 years
  • C.5-10 years
  • D.None of the above

4) ................ describes the data contained in the data warehouse.

  • A. Metadata
  • B.Relational data
  • C.Informational data
  • D.None of the above

5) Which of the following predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions?

  • A. Metadata
  • B.Datamarts
  • C.Data warehouse.
  • D.Data mining
Download Free : Data Warehouse MCQ PDF

6) ................ is the heart of the warehouse.

  • A. Data mart database servers
  • B.Relational data base servers
  • C.Data warehouse database servers
  • D.All of the above

7) ................ is the specialized data warehouse database.

  • A. DBZ
  • B.Oracle
  • C.Informix
  • D.Redbrick

8) Which of the following defines the structure of the data held in operational databases and used byoperational applications?

  • A. User-level metadata.
  • B.Operational metadata.
  • C.Operational metadata.
  • D.Data warehouse metadata.

9) Which of the following consists of information in the enterprise that is not in classical form?

  • A. Data mining
  • B.Mushy metadata.
  • C.Differential metadata.
  • D.None of the above

10) Data can be updated in _____environment.

  • A. Operational
  • B.Data mining
  • C.Informational
  • D.None of the above

11) The source of all data warehouse data is the ....................

  • A. Formal environment
  • B.Informal environment
  • C.Operational environment
  • D.None of the above

12) Data warehouse contains ............. data that is never found in the operational environment.

  • A. Summary
  • B.Normalized
  • C.Informational
  • D.Denormalized

13) Bill Inmon has estimated___________of the time required to build a data warehouse, is consumedin the conversion process.

  • A. 20 percent
  • B.40 percent
  • C.60 percent
  • D.80 percent

14) The generic two-level data warehouse architecture includes ................

  • A. At least one data mart.
  • B.Far real-time updates.
  • C.Near real-time updates.
  • D.None of the above

15) The active data warehouse architecture includes ..................

  • A. At least one data mart.
  • B.Near real-time updates.
  • C.Data that can extracted from numerous internal and external sources
  • D.All of the above

16) Data scrubbing is .............

  • A. A process to upgrade the quality of data after it is moved into a data warehouse
  • B.A process to upgrade the quality of data before it is moved into a data warehouse
  • C.A process to reject data from the data warehouse and to create the necessary indexes
  • D.None of the above

17) The load and index is .......................

  • A. A process to upgrade the quality of data after it is moved into a data warehouse
  • B.A process to upgrade the quality of data before it is moved into a data warehouse
  • C.A process to load the data in the data warehouse and to create the necessary indexes
  • D.None of the above

18) The most common source of change data in refreshing a data warehouse is ...............

  • A. Logged change data
  • B.Snapshot change data
  • C.Queryable change data
  • D.None of the above

19) .................... are responsible for running queries and reports against data warehouse tables.

  • A. Software
  • B.Hardware
  • C.End users
  • D.Middle ware

20) The main organizational justification for implementing a data warehouse is to provide ................

  • A. Access to data
  • B.Decision support
  • C.Storing large volume of data
  • D.Cheaper ways of handling transportation.

21) Data warehouse architecture is based on .................

  • A. DBMS
  • B.Sybase
  • C.RDBMS
  • D.SQL Server

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Oct
Angular 2 MCQ
01st
Feb
MYSQL MCQ
01st
Feb
Asp.Net MCQ
01st
May
AutoCAD MCQ
01st
Mar
Robotics MCQ
01st
Jan
Flutter MCQ