DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Yes
|
|
|
No
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -False. The Data warehouse is not generally updated in real-time.
Detailed explanation-2: -False. The Data warehouse is not generally updated in real-time.
Detailed explanation-3: -The Real-time Data Warehouse (RTDW) is a separate read-only database designed for reporting purposes, also known as the reporting database. The Real-time Data Warehouse is refreshed approximately every 15 minutes or sooner for production environments.
Detailed explanation-4: -Most data warehouses are loaded with new data on a regular schedule. For example, every night, week, or month, new data is brought into the data warehouse. The data being loaded at the end of the week or month typically corresponds to the transactions for the week or month.
Detailed explanation-5: -Real-time data warehousing is used as an information retrieval framework as soon as the data becomes available. In real-time data warehousing, the warehouse updates each time the system executes a transaction.