Group 11 Quiz Game!

It is a relational or multidimensional database that may consume hundreds of gigabytes or even terabytes of disk storage.

• Data Depository

• Data Extraction

• Data Warehouse

• Data Mart

It is when a data warehouse is organized for a single department or faction.

• Data Mining

• Data Mart

• Data Extraction

• Data Cleansing

It is an OLAP technique related to data mining summarizing the views of previously described data.

• Data Mining

• Data Extraction

• Drill-down Capability

• Data Cleansing

It is the process of collecting data from operational databases, flat files, archives, and external data sources.

• Data Extraction

• Data Cleansing

• Data Mining

• Data Warehouse

It is the process of collecting data from operational databases, flat files, archives, and external data sources.

• Data Mining

• Data Extraction

• Data Cleansing

• Data Mart

It is applied in the marketing field in identifying buying patterns and correlations between demographics by examining the historical data and predicting promotional campaigns.

• Drill-down Capability

• Changed Data Capture

• Internal Efficiency

• Data Mining

It can largely reduce the extraction time by capturing only newly modified data.

• Internal Efficiency

• Changed Data Capture

• Data Cleansing

• Data Mining

One reason for a separate data warehouse from operational databases that organize data in a manner that permits broad examination and the detection of underlying trends.

• Consolidation of Local Data

• Internal Efficiency

• Separation of Legacy Systems

 

Data warehouse views are physical tables rather than virtual in nature.

• TRUE

• FALSE

Data warehousing success requires that data warehouse be maintained separately from the operational databases.

• TRUE

• FALSE