FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following features usually applies to data in a data warehouse?
A
Data are often deleted
B
B.Most applications consist of transactions
C
C.Data are rarely deleted
D
D.Relatively few records are processed by applications
Explanation: 

Detailed explanation-1: -Which of the following features usually applies to data in a data warehouse? Explanation: Data are rarely deleted.

Detailed explanation-2: -The four characteristics of a data warehouse, also called features of a data warehouse, include SUBJECT ORIENTED, TIME VARIANT, INTEGRATED and NON-VOLATILE.

Detailed explanation-3: -A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources.

Detailed explanation-4: -Answer-D) Volatile is not a property of the data warehouse.

There is 1 question to complete.