DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Operational data within the organization
|
|
|
Obtained external sources
|
|
|
Statements 1 and 2 are correct
|
|
|
Statements 1 and 2 are wrong
|
Detailed explanation-1: -The data within a data warehouse is usually derived from a wide range of sources such as application log files and transaction applications. A data warehouse centralizes and consolidates large amounts of data from multiple sources.
Detailed explanation-2: -A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources.
Detailed explanation-3: -A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools. All of these components are engineered for speed so that you can get results quickly and analyze data on the fly.