FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Data Warehousing Concepts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

It is always possible to structure a database that can be used in a straightforward manner for both operational and analytical purposes.

Correct Answer

verified

False

Question 2

Essay

Review LaterAdd Note

Review Later

List the three major components of every data warehousing system.

Correct Answer

verified

Source systems,extraction-transformation-load (ETL)infrastructure,and the data warehouse.

Question 3

Essay

Review LaterAdd Note

Explain the term time-variant in the following data warehouse definition: The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Implicit changes of data warehouse requirements are permitted during:

Explain the term integrated in the following data warehouse definition: The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

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

Explain the term detailed and/or summarized data in the following data warehouse definition,and elaborate on the reasons for storing detailed and aggregated data in the data warehouse: The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Explain the term subject-oriented in the following data warehouse definition: The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Data time-horizon is:

Operational queries typically process:

Operational queries are typically issued:

What is the difference between a typical (regular)data warehouse and an active data warehouse?

What is the difference between developing the initial and subsequent versions of the data warehouse?

Separate operational data sources cannot contain overlapping information.

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

Show a diagram that illustrates the principal activities in the process of the development of the data warehouse.

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

Explain the term enterprise-wide in the following data warehouse definition: The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.

Describe the data redundancy difference between operational and analytical database systems.

Explain the term historical in the following data warehouse definition: The data warehouse is a structured repository of integrated,subject-oriented,enterprise-wide,historical,and time-variant data.The purpose of the data warehouse is the retrieval of analytical information.A data warehouse can store detailed and/or summarized data.