Data Warehouse - Foundations

Which is not a property of data warehouse?

• subject oriented

• time variant

• collection from heterogeneous sources

• volatile

data warehousing used in_______________

• transaction system

• decision support system

What are the characeristics of OLAP systems?

• query driven

• integrated

• less users

• store current data

Which system is application oriented?

• Online transaction processing system

• Online analytical processing system

Which operation can perform on data warehouse?

• read/write

• modify

• alter

• scan

data warehouse is based on_____________

• two dimensional model

• three dimensional model

• multidimensional model

• unidirectional model

Data warehousing is related to______

• create data warehouse

• update data

• scan and load data for analysis

• write new data

What is a Data Mart?

• A data mart is a subgroup of the data warehouse
• A data mart is another type of data warehouse
• A data mart is not actually related to data warehouses
• None of these

A basic concept of data warehouse is which of the following?

• Can be updated by end users.

• Contains numerous naming conventions and formats.

• Store the data in formats suitable for easy access for decision making.

• Contains only current data.

Which schema is best for data warehouse development?

• 
•