Ch 7 (Data warehousing concepts)
The operational data sources include the data warehouses and data marts.
False
Operational queries are typically issued:
More often than analytical queries
Which of the following is an example of a subject-oriented data set. -data set enabling entry of new savings accounts -data set enabling entry of new loan aplicants -data set on the back end of an ATM machine Data set enabling entry of new checking accounts
None of these
Operational queries typically process:
Smaller amounts of data than analytical queries
Which of the following is likely to be a user of a bank's data warehouse
bank's CEO
Two common abbreviations with data warehouses are BI and OLAP. What does each stand for?
business intelligence and online analytical processing
Which of the following is a part of the data warehouse requirements step?
Conceptual modeling
Which of the following would typically be stored in target (data warehousing) systems? -summarized -subject-oriented detailed derived
All of these are typically present in target systems.
Due to the amount of details that have to be considered, creating _________________ is often the most time- and resource-consuming part of the data warehouse development process
ETL infrastructure
Implicit changes of data warehouse requirements are permitted during:
Implicit changes of requirements are not permitted
A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.
True
A typical organization maintains and utilizes a number of operational data sources.
True
Data warehouse requirements can be refined and/or expanded following: data warehouse deployment data warehouse modeling creating etl data warehouse use
All of these
Which of the following is NOT true:
Data marts typically have more subjects of analysis than data warehouses
Which of the following would typically be stored in source (operational databassystems?
Detailed data
The performance of operational day-to-day tasks involving data use can be severely diminished if such tasks have to compete for computing resources with analytical queries.
True
Data time-horizon is:
Typically, shorter in operational systems than in analytical systems
The purpose of the source system is:
Both the original operational purpose and as a source system for the data warehouse
Operational queries are typically issued:
By more users than analytical queries
Which of the following differences, renders normalization of data warehouses unnecessary?
Data Update difference and data redundancy difference