DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Read
|
|
|
Write
|
|
|
Both
|
|
|
None of the above
|
Detailed explanation-1: -Data is read-only. It cannot be changed by end users. IV. Data is historical and represents a series of snapshots depicting the state of businesses at different points in time.
Detailed explanation-2: -Data warehouses are typically set to read-only for analyst users, who are primarily reading and aggregating data for insights. Since data is already clean and archival, there is usually no need to insert or update data.
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: -12. What is the time horizon in the data warehouse? Answer-C) The time horizon in the data warehouse is 5-10 years. 13.