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