COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Data Warehouse is usually used for?
|
Accommodates historical data for many years
|
|
Organizing daily data
|
|
Statements 1 and 2 are correct
|
|
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.