1) The analysis of summarized data to support decision making is called:
A) operational processing.
B) informational processing.
C) artificial intelligence.
D) data scrubbing. - Answers B
2) The characteristic that indicates that a data warehouse is organized around key high-level
entities of the enterprise is:
A) subject-oriented.
B) integrated.
C) time-variant.
D) nonvolatile. - Answers A
3) When we consider data in the data warehouse to be time-variant, we mean:
A) that the time of storage varies.
B) data in the warehouse contain a time dimension so that they may be used to study trends and
changes.
C) that there is a time delay between when data are posted and when we report on the data.
D) none of the above. - Answers B
4) Which of the following advances in information systems contributed to the emergence of data
warehousing?
A) Improvements in database technology, particularly the relational data model
B) Advances in computer hardware, especially affordable mass storage and parallel computer
architectures
C) Advances in middleware products that enabled enterprise database connectivity across
heterogeneous platforms
D) All of the above - Answers D
5) Which of the following factors drive the need for data warehousing?
A) Businesses need an integrated view of company information.
B) Informational data must be kept together with operational data.
C) Data warehouses generally have better security.
D) None of the above - Answers A
Which of the following organizational trends does not encourage the need for data
warehousing?
A) Multiple, nonsynchronized systems
B) Focus on customer relationship management
C) Downsizing
D) Focus on supplier relationship management - Answers C
Informational systems are designed for all of the following EXCEPT:
A) running a business in real time.
B) supporting decision making.
C) complex queries.
D) data mining. - Answers A
Operational and informational systems are generally separated because of which of the
following factors?
A) A data warehouse centralizes data that are scattered throughout disparate operational systems
and makes them readily available for decision support applications.
B) A properly designed data warehouse adds value to data by improving their quality and
consistency.
C) A separate data warehouse eliminates contention for resources that results when informational
applications are confounded with operational processing.
D) All of the above - Answers D
9) A data mart is a(n):
A) enterprisewide data warehouse.
B) smaller system built upon file processing technology.
C) data warehouse that is limited in scope.