COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEMS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Data Warehouse is usually used for?
A
Accommodates historical data for many years
B
Organizing daily data
C
Statements 1 and 2 are correct
D
Statements 1 and 2 are wrong
Explanation: 

Detailed explanation-1: -Data warehousing systems are usually concerned with historical data. Data within operational systems are mainly updated regularly according to need. Non-volatile, new data may be added regularly. Once Added rarely changed.

Detailed explanation-2: -A data warehouse stores current and historical data for the entire business and feeds BI and analytics. Data warehouses use a database server to pull in data from an organisation’s databases and have additional functionalities for data modelling, data lifecycle management, data source integration, and more.

There is 1 question to complete.