Question

Which of the following is a characteristic of data warehouse
1. The data in warehouse is backup for operational database
2.the data warehouse is optimised for generating reports
3.data warehouse can not include data from external sources
4.the data in warehouse is not integrated

Answer 1

Answer:

The Correct option is (1) The data in warehouse is backup for operational database.

Explanation:

A Data warehouse is defined as a central information repository that is a component of a Business Intelligence system, whereas a database is a collection of data that gives us real time data analysis.

The major characteristic of a  data warehouse is that it is subject-oriented time - variant, integrated and non-volatile .

We have 4 stages of Data Warehouse processing that are offline database, offline data warehousing , real time data Warehousing and integrated Data warehousing.