Chapter 7 FINAL

Operational queries are typically issued: A) More often than analytical queries B) Less often than analytical queries C) Equally as often as analytical queries D) Never in a corporation that has users issuing analytical queries

A) More often than analytical queries

Operational queries are typically issued: A) By fewer users than analytical queries B) By more users than analytical queries C) By an equal number of users as analytical queries D) By no users if the corporation has users issuing analytical queries

B) By more users than analytical queries

Operational queries typically process: A) Larger amounts of data than analytical queries B) Smaller amounts of data than analytical queries C) Equal amounts of data as analytical queries D) Infinite amounts of data, incomparable to analytical queries

B) Smaller amounts of data than analytical queries

Which of the following is likely to be a user of a bank's data warehouse? A) Bank's customer B) Bank's security office C) Bank's CEO D) Bank's teller E) None of the above

C) Bank's CEO

The purpose of the source system is: A) Original operational purpose only B) As a source system for the data warehouse only C) Both the original operational purpose and as a source system for the data warehouse D) As a write-only source system

C) Both the original operational purpose and as a source system for the data warehouse

Which of the following is a part of the data warehouse requirements step? A) Data warehouse deployment B) Creating ETL Infrastructure C) Conceptual modeling D) All of the above

C) Conceptual modeling

Data time-horizon is: A) Typically longer in operational systems than in analytical systems B) Typically equal in operational systems and in analytical systems C) Typically shorter in operational systems than in analytical systems D) Typically nonexistent in operational systems and in analytical systems

C) Typically, shorter in operational systems than in analytical systems