FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following is TRUE for 3-tier data warehouses?

A	Once created, the data marts will directly receive their new data from the operational databases
B	A data mart becomes a data warehouse when it reaches a critical size
C	The data marts are different groups of tables in the data warehouse
D	Once created, the data marts will keep on being updated from the data warehouse at periodic times

Explanation:

Detailed explanation-1: -Once created, the data marts will keep on being updated from the data warehouse at periodic times. A data mart becomes a data warehouse when it reaches a critical size.

Detailed explanation-2: -The operational data are used as a source for the data warehouse. An operational system is used to run the business in real time and is based on current data.

Detailed explanation-3: -Data Warehouses usually have a three-level (tier) architecture that includes: Bottom Tier (Data Warehouse Server) Middle Tier (OLAP Server) Top Tier (Front end Tools).

Detailed explanation-4: -Explanation: The DBMS three-tier architecture is the most common client-server architecture in the DBMS, where functional processes, logic, data access, data storage, and user interface development and maintenance are performed independently as separate modules . So, the correct answer it all of these .

Detailed explanation-5: -Process Flow in Data Warehouse Extract and load the data. Cleaning and transforming the data. Backup and archive the data.

There is 1 question to complete.