DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data integration and Data Mining
|
|
|
Data Mining and Data Storage
|
|
|
Reporting and Data Analysis
|
|
|
Data Cleaning and Data Storage
|
Detailed explanation-1: -A Data warehouse is typically used to connect and analyze business data from heterogeneous sources. The data warehouse is the core of the BI system which is built for data analysis and reporting.
Detailed explanation-2: -Data warehouses are relational environments that are used for data analysis, particularly of historical data. Organizations use data warehouses to discover patterns and relationships in their data that develop over time.
Detailed explanation-3: -A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence.
Detailed explanation-4: -A data warehouse is a system used for reporting and data analysis. The data warehouse is a central repository of integrated data from one or more separate sources of data. The extract, transform, and load (ETL) process prepares the data for use by the data warehouse.
Detailed explanation-5: -Answer-C) System of data warehousing is mostly used for Reporting and data analysis.