FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Data Warehousing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

In three-tier architecture for data warehouse,________ contain the data and the software for data acquisition in one tier,the data warehouse is another tier,and the third tier includes the decision support and the client.

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

A data warehouse contains numerous ________ that define such things as how the data will be used,summarization rules,standardization of encoded attributes,and calculation rules.

Correct Answer

verified

Show Answer

Question 23

Essay

Review LaterAdd Note

________ is the process of loading and provides data via the data warehouse as they become available.

Data often are fragmented in distinct operational systems,so managers often make decisions with partial information at best.________ cuts through this obstacle by accessing,integrating,and organizing key operational data in a form that is consistent,reliable,timely,and readily available where needed.

The ________ is a scaled-down version of the data warehouse that centers on the requests of a specific department,such as marketing or sales.

When DirectTV decided to implement an active data warehouse solution,the goal of the new system was to send fresh data to the call center at least daily.Once the capabilities of the solutions became apparent,that goal:

Which of the following are created when operational data need to be analyzed multidimensionally?

There are five levels of metadata management maturity that can be used to describe where an organization is in terms of how and how well it utilizes its metadata.

Data warehouse is a(n) ________,integrated,time-variant,nonvolatile collection of data in support of management's decision making process.

The main issues pertaining to ________ are the amount of data in the warehouse,how quickly the warehouse is expected to grow,the number of concurrent users,and the complexity of user queries.

According to conventional wisdom,independent data marts are a poor architectural solution.

Users demanding access via PDAs and through speech recognition and synthesis is becoming more commonplace,further complicating ________ issues.

________ is the person responsible for the administration and management of a data warehouse.

Once data are entered into the warehouse,users cannot change or update the data.Obsolete data are discarded,and changes are recorded as new data.This ________ characteristic is one of the characteristics of data warehousing.

The data warehouse design is based upon the concept of ________ modeling,which is a retrieval-based model that supports high-volume query access.

Which of the following is not a direct benefit of a data warehouse?

Operational data store is used for the medium- and long-term decisions associated with the enterprise data warehouse (EDW).

List four characteristics of a data warehouse.

There are many middleware tools that business users can use to access data stored in the data repositories,including data mining,reporting tools,and data visualization.

Data warehouses contain vast amounts of internal data but are limited because they do not contain external data.