DWDM-QUIZ1

OLTP used for _______.

• Day to Day operation

• Quaterly operation

• Monthly operation

• Yearly operation

In general time horizon of data warehouse is___________

• 1 to 2 year

• 3 -4 years

• 5-6 yeards

• 5 - 10 years

The typical data source for a data warehouse is__________.

• All of the above

• Operational databases

• External APIs

• Flat files

The data warehouse is ______

• Read Only

• Write only

• ReadWrite only

• None

In general data in datawarehouse is----------------

• Normalized

• Denormalized

• none

• All of above

---------------model used in Datawarehouse.

• 1D

• 2D

• 3D

• Multidimensional

Where is Data warehousing used?

• Transaction system

• Logical System

• Decision support System

• None

MDDB stands for-----------

• Multidimensional Doubling

• Multidimensional database

• Multiplr data dubbing

• Multiple double  dimension

OLAP Stands for__________

• Online Analytical Processing

• Offline Analysis Processing

• Onset Analytical Processing

• Online Analysis Processing

What is the primary purpose of a Data Warehouse?

• Store Operational Data

• Support BI

• Manage Transactional Data

• To Faciliate Real time processing