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