Quiz 7

True or False? A data mart is a data store based on the same principles as a data warehouse but with a wider scope.

False

True or False? Analytical databases are referred to as application-oriented.

False

True or False? In contrast to a narrow constituency of operational data, analytical data is used by a widespread set of users.

False

True or False? It is usually possible to configure the back-end system to optimally process frequent queries requiring smaller amounts of data and to optimally process less frequent queries requesting large amounts of data at the same time.

False

True or False? Operational databases are referred to as subject-oriented.

False

True or False? Separate operational data sources cannot contain overlapping information.

False

Operational queries are typically issued:

More often than analytical queries

True or False? A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis.

True

Data time-horizon is:

Typically, shorter in operational systems than in analytical systems

Creating ETL infrastructure includes creating necessary procedures and code for:

Transformation of the extracted data, so that its quality is assured and its structure conforms to the structure of the modeled and implemented data warehouse

True or False? Analytical databases are created for the analysis of one or more specific business subject areas, such as sales, returns, cost, or profit.

True

True or False? Data warehouse front-end-applications are often referred to as business intelligence (BI) applications.

True

True or False? 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 warehouse requirements can be refined and/or expanded following:

All of the above (data warehouse use, data warehouse deployment, creating ETL infrastructure, and data warehouse modeling)

The purpose of the source system is:

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

Which of the following is NOT true:

Data marts typically have more subjects of analysis than data warehouses

Which of the following difference renders normalization of data warehouses unnecessary?

Data update difference and data redundancy difference

Which of the following would typically be stored in source (operational database) systems?

Detailed data

Operational queries are typically issued:

By more users than analytical queries

Which of the following would typically be stored in target (data warehousing) systems?

All of the above is typically present in target systems (subject-oriented data, derived data, summarized data, & detailed data)

Operational queries typically process:

Smaller amounts of data than analytical queries

Implicit changes of data warehouse requirements are permitted during:

Implicit changes of requirements are not permitted

Which of the following is a part of the data warehouse requirements step?

Logical modeling

True or False? Summarized operational data is typically physically stored, while summarized analytical data is typically derived (calculated) rather than physically stored.

False