DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
data stored in the various operational systems throughout the organization.
|
|
|
current data intended to be the single source for all decision support systems.
|
|
|
data stored in one operational system in the organization.
|
|
|
data that has been selected and formatted for end-user support applications.
|
Detailed explanation-1: -Reconcile data is data stored in one operational system in the organization. Reconcile data is the data that has been selected and formatted for end-user support applications. Answer-C) Reconcile data is the current data intended to be the single source for all decision support systems.
Detailed explanation-2: -Reconciled data could be stated as current data intended to be the single source for all decision support.
Detailed explanation-3: -Data that has been selected and formatted for end-user support applications. Data stored in one operational system in the organization. Data stored in the various operational systems throughout the organization.
Detailed explanation-4: -The reconciled layer in this architecture sits between the source and data warehouse layer and acts as a standard reference for an enterprise data model. However, although this layer introduces better data quality for warehouses, the additional storage space incurs extra costs.
Detailed explanation-5: -Why Is Data Reconciliation Important? The process of data reconciliation can help reduce errors, improve accuracy, increase efficiency and improve decision-making. It can also provide valuable insights into sources of data and be used as a tool for detecting fraud or potential errors.