COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The data source for the data warehouse is ____
|
Operational data within the organization
|
|
Obtained external sources
|
|
Statements 1 and 2 are correct
|
|
Statements 1 and 2 are wrong
|
Explanation:
Detailed explanation-1: -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 organization’s databases and have additional functionalities for data modeling, data lifecycle management, data source integration, and more.
Detailed explanation-2: -Enterprise Data Warehouse (EDW) This type of warehouse serves as a key or central database that facilitates decision-support services throughout the enterprise. Operational Data Store (ODS) This type of data warehouse refreshes in real-time. Data Mart. 23-Feb-2023
There is 1 question to complete.