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 31

True/False

Review LaterAdd Note

Review Later

Operational data typically represents the current state of affairs in the real world,while analytical data can represent both the current situation and snapshots from the past.

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Essay

Review LaterAdd Note

Review Later

Explain the term retrieval of analytical information 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.

Correct Answer

verified

A data warehouse is developed for the re...

View Answer

Show Answer

Question 33

True/False

Review LaterAdd Note

Data marts are always implemented as relational databases.

Operational queries are typically issued:

Describe the data warehouse deployment step.

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

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.

Operational databases are referred to as subject-oriented.