DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Can be updated by end users.
|
|
|
Contains numerous naming conventions and formats.
|
|
|
Store the data in formats suitable for easy access for decision making.
|
|
|
Contains only current data.
|
Detailed explanation-1: -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-2: -Data warehouses store data from multiple databases, which makes it easier to analyze. Databases are used in data warehousing. However, the term usually refers to an online, transactional processing database. There are other types as well, including csv, html, and Excel spreadsheets used for database purposes.
Detailed explanation-3: -All data warehouses share a basic design in which metadata, summary data, and raw data are stored within the central repository of the warehouse. The repository is fed by data sources on one end and accessed by end users for analysis, reporting, and mining on the other end.
Detailed explanation-4: -Once in the data warehouse, the data is ingested, transformed, processed, and made accessible for use in decision-making. The three main types of data warehouses are enterprise data warehouse (EDW), operational data store (ODS), and data mart.