Data Warehouse MCQ

Data Warehouse MCQ

  • Admin
  • 16th Jul, 2021

Data Warehouse MCQ

Following are mostly asked Data warehouse MCQ test that are designed for professionals like you to crack you interviews. You can take this Data warehouse online test before appearing to you real interview. This Data warehouse quiz there are around 30+ multiple choice questions on Data warehouse with four options.

1) A data warehouse is ...............

  • A. Updated by end users
  • B. Contains only current data
  • C. Organized around important subject areas.
  • D. None of the Above

2) The data from the operational environment enter _______ of data warehouse.

  • A. Older detail data.
  • B. Current detail data.
  • C. Highly summarized data
  • D. Lightly summarized data.

3) What does metadata contains atleast?

  • A. The structure of the data.
  • B. The algorithms used for summarization
  • C. The mapping from the operational environment to the data warehouse.
  • D. All of the Above

4) A directory to help the DSS analyst locate the contents of the data warehouse is seen in .............

  • A. Metadata
  • B. Older detail data
  • C. Current detail data.
  • D. Lightly summarized data

5) Which is not a component of a data warehouse?

  • A. Metadata
  • B. Component Key
  • C. Current detail data
  • D. Lightly summarized data
Download Free : Data Warehouse MCQ PDF

6) How many components are there in a data warehouse?

  • A. 2
  • B. 3
  • C. 4
  • D. 5

7) Building the informational database is done with the help of .............

  • A. Extraction tools
  • B. Propagation tools only.
  • C. Transformation tools only
  • D. Transformation or propagation tools.

8) ............ contains information that gives users an easy-to-understand perspective of the information stored in the data warehouse?

  • A. Business metadata
  • B. Operational metadata.
  • C. Technical metadata
  • D. None of the above

9) The full form of KDD is ............

  • A. Knowledge database
  • B. Knowledge data house
  • C. Knowledge data definition
  • D. Knowledge discovery in database

10) ............ is a metadata repository.

  • A. CORBA
  • B. STUNT
  • D. Prism solution directory manager.

11) Which of the following is data collected from natural systems?

  • A. MRI scan
  • B. ODS data
  • C. Historical data
  • D. Statistical data

12) Which of the following is data about data?

  • A. Minidata
  • B. Multidata
  • C. Metadata
  • D. Microdata

13) Data warehouse architecture is based on the .............

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

14) 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.

15) Which of the following are responsible for running queries and reports against data warehouse tables?

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

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz