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 21

True/False

Review LaterAdd Note

Review Later

A real-time data warehouse together with a decision support system that leverages integrated data can provide significant financial benefits for an organization.

A) True
B) False

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

True/False

Review LaterAdd Note

There are ethical considerations involved in the collection and ownership of the information contained in metadata, including privacy and intellectual property issues.

________ is a subset that is created directly from the data warehouse. It has the advantages of using a consistent data model and providing quality data.

In a three-tier architecture, operational systems contain the data and the software for data acquisition in the first tier, the data warehouse is a second tier, and the third tier includes the DSS/BI/BA engine.

Once the data are properly stored in a data warehouse, that data can be used in various ways to support organizational ________.

________ comprises three major processes that, when correctly implemented, permits data to be accessed and made accessible to an array of ETL and analysis tools and data warehousing environment.

Which of the following is one of the components of data warehousing process that enables users to access the data warehouse?

There are three main types of data warehouses, which are data marts, operational data stores, and enterprise data warehouses.

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

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.

Identify five data warehouse best practices.

Describe various integration technologies that enable data and metadata integration.

Which of the following 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?

Which of the following is needed to determine how data are to be retrieved from a data warehouse, and will assist in the physical definition of the warehouse by helping to define which data require indexing?

The advantage of three-tier architecture for data warehousing is its separation of the functions of the data warehouse, which eliminates resource constraints and makes it possible to easily create data ________.

List four fundamental characteristics of a data warehouse.

Effectiveness, extensibility, reusability, interoperability, efficiency and performance, evolution, entitlement, flexibility, segregation, user interface, versioning, versatility, and low maintenance cost are some of the key requirements for building a successful metadata-driven enterprise.

Guidelines that need to be considered when developing a vendor list include all of the following except:

What are the issues to consider when deciding which architecture for data warehousing to use?