DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It can be updated by end users
|
|
|
It can solve all business questions
|
|
|
It is designed for focus subject areas
|
|
|
It contains only current data
|
Detailed explanation-1: -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-2: -A data warehouse is specially designed for data analytics, which involves reading large amounts of data to understand relationships and trends across the data. A database is used to capture and store data, such as recording details of a transaction.
Detailed explanation-3: -A system that is used to run the business in real time and is based on historical data.
Detailed explanation-4: -Subject areas within a data warehouse or data mart are physical tables that are grouped together in a dimensional model or star schema that reflect general data or functional categories.