FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Data Warehousing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

Data warehouses are subsets of data marts.

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

Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.

Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?

Online ________ is arguably the most commonly used data analysis technique in data warehouses.

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?

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT

One way an operational data store differs from a data warehouse is the recency of their data.

How does the use of cloud computing affect the scalability of a data warehouse?

Mention briefly some of the recently popularized concepts and technologies that will play a significant role in defining the future of data warehousing.

All of the following are true about in-database processing technology EXCEPT

Mehra (2005) indicated that few organizations really understand metadata, and fewer understand how to design and implement a metadata strategy. How would you describe metadata?

In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database.

What is the definition of a data mart?

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.

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

All of the following are benefits of hosted data warehouses EXCEPT

________ 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.