Chapter 7 and 8

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

Typically, in a star schema all ________ are given a simple, non-composite system-generated primary key, also called a surrogate key. A) Fact tables B) Dimension tables C) Transaction identifiers D) Measures

B) Dimension tables

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

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

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

________ contain descriptions of the business, organization, or enterprise to which the subject of analysis belongs. A) Fact tables B) Dimension tables C) Both dimension and fact tables D) Neither dimension nor fact tables

B) Dimension tables

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

The dimensional schema is often referred to as the: A) Fact table B) Dimension table C) Star schema D) Transaction schema

C) Star schema

________ contain measures related to the subject of analysis. A) Fact tables B) Dimension tables C) Both dimension and fact tables D) Neither dimension nor fact tables

A) Fact tables

Which of the following column names would not appear in a fact table? A) SalesTransactionID B) Product Key (FK) C) TimeOfDay D) UnitsSold E) Product Name

E) Product Name

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

In a typical properly-designed star schema, the number of records/rows in any of the dimension tables is: A) Larger than in the fact table B) Same as in the fact table C) Smaller than in the fact table D) No typical rule—there is a similar number of dimension tables with larger, smaller and same number of records as in the fact table

C) Smaller than in the fact table

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