Data Warehouse MCQ Questions

Data Warehouse MCQ Questions

  • 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.

Latest Interview Questions

img
API Testing Interview Questions 08th Aug, 2022
img
Celery Interview Questions 25th Nov, 2021
img
Solaris Interview Questions 24th Feb, 2021
img
Telematics Interview Questions 05th Mar, 2021
img
UFT Interview Questions 08th Aug, 2022
img
Terraform Interview Questions 23rd Nov, 2021

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.

Latest Posts

img
Login With Google using PHP 18th Nov, 2019
img
Working with expressions In Angular JS? 01st Nov, 2019
img
What is AngularJS? Why it is Used. 16th Nov, 2019

Latest MCQ Questions

img
Arduino MCQ Questions 08th Dec, 2021
img
3D Printing MCQ 23rd Nov, 2021
img
Bioinformatics MCQ Questions 12th Mar, 2022
img
Business Intelligence MCQ 15th Apr, 2022
img
Salesforce MCQ 28th Feb, 2022
img
SAP ABAP MCQ 05th Mar, 2022

Related MCQ/Quiz

01st
Nov
Social Media Marketing MCQ

Social Media Marketing MCQ

01st
Nov
Fiber Optics MCQ

Fiber Optics MCQ

01st
Jun
Operating System MCQ Questions

Operating System MCQ Questions

01st
Nov
Appium MCQ Questions

Appium MCQ Questions

01st
Nov
Data Structure MCQ

Data Structure MCQ

01st
Nov
Cobol MCQ

Cobol MCQ