COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEMS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The data source for the data warehouse is ____
A
Operational data within the organization
B
Obtained external sources
C
Statements 1 and 2 are correct
D
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.