Data Warehouse MCQ Questions

Data Warehouse MCQ Questions | Freshers & Experienced

  • Satyam Jaiswal
  • 22nd May, 2021

We are introducing here the best Data Warehouse MCQ Questions, which are very popular & asked various times. This Quiz contains the best 25+ Data Warehouse MCQ with Answers, which cover the important topics of Data Warehouse so that, you can perform best in Data Warehouse exams, interviews, and placement activities.

Data Warehouse MCQ Questions

1) A data warehouse is __________.

  • A. Organized by google
  • B.Organized around important subject areas
  • C.Contains only real time data
  • D.All of the above

2) The types of tables a snowflake schema is _________.

  • A. Helper
  • B.Fact
  • C.Dimension
  • D.All of the above

3) The relationship between a dimension and fact table of a star schema is ___________.

  • A. One-to-one
  • B.One-to-many
  • C.Many-to-many
  • D.All of the above

4) Transient data is the data in which changes to existing records cause the previous version of the records to be eliminated. True/False.

  • A. True
  • B.False

5) Reconciled data is the current data intended to be the single source for all decision support systems. Yes/No?

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

6) The generic two-level data warehouse architecture includes __________.

  • A. Only current data
  • B.maximum 10 datamart
  • C.Data that can extracted from numerous internal and external sources
  • D.None of the above

7) The extract process is used to capture a subset of the data contained in various decision support systems.

  • A. True
  • B.False

8) The extract process is used to capture a subset of the data contained in various operational systems.

  • A. True
  • B.False

9) 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

10) OLAP stands for _________.

  • A. Online Analytical Procedure
  • B.Online Analytical Performance
  • C.Online Analytical Processing
  • D.None of the above

11) _________ can be used as a better alternative of Star schema.

  • A. Bus schema
  • B.Snowflake schema
  • C.Fact constellation
  • D.None of the above

12) The data Warehouse is __________.

  • A. write only
  • B.read only
  • C.Both A and B
  • D.None of the above

13) In data Warehouse DSS stands for __________.

  • A. Decision Support Stream
  • B.Decision Study System
  • C.Decision Support System
  • D.None of the above

14) The data contained in the data warehouse is known as __________.

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

15) __________ is the specialized data warehouse database.

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

16) __________ defines the structure of the data held in operational databases and used by operational applications.

  • A. User-level metadata
  • B.Operational metadata
  • C.Both A and B
  • D.None of the above

17) Can we update record in data warehouse?

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

18) The test is used in an online transactional processing environment is known as __________ test.

  • A. MICRO
  • B.Black box
  • C.ACID
  • D.None of the above

19) The load and index is a process to load the data in the data warehouse and to create the necessary indexes.

  • A. True
  • B.False

20) Fact tables are _________.

  • A. Partially normalized
  • B.Completely normalized
  • C.Both A and B
  • D.None of the above

21) The method of incremental conceptual clustering is known as ___________.

  • A. STING
  • B.OLAP
  • C.COBWEB
  • D.None of the above

22) Multidimensional database is also known as ___________.

  • A. EXTENDED RDBMS
  • B.EXTENDED DBMS
  • C.RDBMS
  • D.DBMS

23) ____________ is a data transformation process.

  • A. Projection
  • B.Selection
  • C.Filtering
  • D.None of the above

24) SMP stands for ___________.

  • A. Symmetric Multiprocessor
  • B.Symmetric Multiprogramming
  • C.Symmetric Multiprocessing
  • D.None of the above

25) MDDB stands for ________.

  • A. Multiprocessor databases
  • B.Multidimensional databases
  • C.Multidigonal databases
  • D.None of the above

26) Some popular OLAP tools are _________.

  • A. Metacube
  • B.Informix
  • C.Both A and B
  • D.None of the above

27) The term data warehouse was coined by ________.

  • A. James Gosling
  • B.Bill Inmon
  • C.Guido van Rossum
  • D.All of the above

28) Removing duplicate records is a process known as data cleaning.

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

29) Granularity is determined by ________.

  • A. granularity of those parts
  • B.number of parts to a key
  • C.Both A and B
  • D.None of the above

30) The generic two-level data warehouse architecture includes _________.

  • A. near real-time updates
  • B.far real-time updates
  • C.Both A and B
  • D.None of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Feb
CICS MCQ
01st
Feb
IOS Swift MCQ
01st
Jun
Hadoop MCQ