Data Warehouing

The active data warehouse architecture includes which of the following?

• At least one data mart

• Data that can extracted from numerous internal and external sources

• Near real-time updates

• All of the above

________ was considered as the father of the Data Warehouse

• Paul Murphy

• Inmon Bill

• Barry Devlin

• None

A data warehouse is which of the following?

• Can be updated by end users.

• Contains numerous naming conventions and formats

• Organized around important subject areas

• Contains only current data.

A goal of data mining includes which of the following?

• To explain some observed event or condition

• To confirm that data exists

• To analyze data for expected relationships

• To create a new data warehouse

The extract process is which of the following?

• Capturing all of the data contained in various operational systems

• Capturing a subset of the data contained in various operational systems

• Capturing all of the data contained in various decision support systems

• Capturing a subset of the data contained in various decision support systems

Data in operational systems are typically fragmented and inconsistent.

• True

• False

The role of the ETL process is to identify erroneous data and to fix them.

• True

• False

……………………. is a subject-oriented, integrated,time-variant, nonvolatile collection or data in support of management decisions

• Data Mining

• Data Warehousing

• Document Mining

• Text Mining

The data is stored, retrieved and updated in ………………..

• OLAP

• OLTP

• SMTP

• FTP

An ……………… system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.

• OLAP

• OLTP

• Both of the above

• None of the above