Data Warehousing [Knowledge Check]

What is Data Warehouse ?

• Relational Database Designed for Analysis

• Non-Relational Database Designed for Analysis

What is TIME VARIANT means ?

• Data in Data Warehouse is Valid at Some Point in Time or Over Time Interval

• Data in Data Warehouse is Always Valid

• Data in Data Warehouse is Accurate Sometimes

• Data in Data Warehouse is Snapshot Data

OLTP is stands for ...

• Online Transaction Processing

• Online Transfer Processing

• Online Traffic Processing

Data about data is called ...

• Metadata

• Data description

Who use Data Warehouse ?

• Manager

• Head of Department

• Sales Representative

• Data Analyst

• Chief Officer

Data is retrieved and stored as one from different sources

• Interrupted

• Interpret

• Integrated

• International

Data mart is child of data warehouse.

• True

• False

• Maybe

• I don't know

In the early stages, 4 significant factors drove companies to move into data warehouse, EXCEPT ...

• Fierce Competition

• Need to Revamp Internal Process

• Data Government

• Having Nice Place to Store Metadata

Characteristics of Data Warehousing ...

• Mostly read access

• Less user

• Snapshot data

• Summarized data

• Redundancy is most likely possible

Data warehouse is ...

• Two dimensional model

• Three dimensional model

• Quadruple dimensional model

• Mega dimensional model

• Multi dimensional model