FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Data Warehousing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives,computers,and networks.

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

With ________ data flows,managers can view the current state of their businesses and quickly identify problems.

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

More data,coming in faster and requiring immediate conversion into decisions,means that organizations are confronting the need for real-time data warehousing (RDW).How would you define real-time data warehousing?

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?

The role responsible for successful administration and management of a data warehouse is the ________,who should be familiar with high-performance software,hardware,and networking technologies,and also possesses solid business insight.

________,or "The Extended ASP Model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet)

In the Michigan State Agencies case,the approach used was a(n)________ one,instead of developing separate BI/DW platforms for each business area or state agency.

In the MultiCare case,how was data warehousing able to reduce septicemia mortality rates in MultiCare hospitals?

Moving the data into a data warehouse is usually the easiest part of its creation.

Large companies,especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses.

A common way of introducing data warehousing is to refer to its fundamental characteristics.Describe three characteristics of data warehousing.

________ is a mechanism that integrates application functionality and shares functionality (rather than data)across systems,thereby enabling flexibility and reuse.

There are several basic information system architectures that can be used for data warehousing.What are they?

Data warehouses provide direct and indirect benefits to using organizations.Which of the following is an indirect benefit of data warehouses?

________ is a mechanism for pulling data from source systems to satisfy a request for information.It is an evolving tool space that promises real-time data integration from a variety of sources,such as relational databases,Web services,and multidimensional databases.

What is the definition of a data mart?

A well-designed data warehouse means that user requirements do not have to change as business needs change.

All of the following are benefits of hosted data warehouses EXCEPT

Data ________ comprises data access,data federation,and change capture.

Active data warehousing can be used to support the highest level of decision making sophistication and power.The major feature that enables this in relation to handling the data is