DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A system that is used to process the day-to-day transactions of an organisation
|
|
|
A system that sets up the data warehouse
|
|
|
A system that runs the data warehouse
|
|
|
A system that identifies error in the data warehouse
|
Detailed explanation-1: -An operational system is a term used in data warehousing to refer to a system that is used to process the day-to-day transactions of an organization. These systems are designed in a manner that processing of day-to-day transactions is performed efficiently and the integrity of the transactional data is preserved.
Detailed explanation-2: -A system that is used to run the business in real-time and is based on historical data.
Detailed explanation-3: -A data warehouse is a system that stores data from a company’s operational databases as well as external sources. Data warehouse platforms are different from operational databases because they store historical information, making it easier for business leaders to analyze data over a specific period of time.
Detailed explanation-4: -Answer-C) System of data warehousing is mostly used for Reporting and data analysis.
Detailed explanation-5: -Process Flow in Data Warehouse Extract and load the data. Cleaning and transforming the data. Backup and archive the data.