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