mis 430 ch7, 8 review

Which of the following is NOT true: Data marts typically have narrower focus than data warehouses Data marts are typically not as big as data warehouses Data marts typically have fewer data sources than data warehouses Data marts typically have more subjects of analysis than data warehouses

Data marts typically have more subjects of analysis than data warehouses

________ contain measures related to the subject of analysis. Fact tables Dimension tables Both dimension and fact tables Neither dimension nor fact tables

Fact tables

Operational queries typically process: Larger amounts of data than analytical queries Infinite amounts of data, incomparable to analytical queries Smaller amounts of data than analytical queries Equal amounts of data as analytical queries

Smaller amounts of data than analytical queries

Data time-horizon is: In about half cases longer in operational systems and in about half cases shorter in operational systems Typically, longer in operational systems than in analytical systems Typically, equal in operational systems and in analytical systems Typically, shorter in operational systems than in analytical systems

Typically, shorter in operational systems than in analytical systems

The dimensional schema is often referred to as the: Fact table Dimension table Star schema Transaction schema

star schema

The purpose of the source system is: Both the original operational purpose and as a source system for the data warehouse Original operational purpose only Either as the original operational purpose or as a source system for the data warehouse, but not both As a source system for the data warehouse only

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

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

Dimension tables

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

Dimension tables

Which of the following is likely to be a user of a bank's data warehouse: Bank's customer Bank's CEO Bank's teller None of the above

Bank's CEO

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

Conceptual modeling

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

Smaller than in the fact table

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

Product Name

Operational queries are typically issued: By a singular user in a corporation By more users than analytical queries By an equal number of users as analytical queries By fewer users than analytical querie

By more users than analytical queries

Operational queries are typically issued: Equally as often as analytical queries More often than analytical queries Less often than analytical queries Only to verify the results of analytical queries

More often than analytical queries