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 1

Essay

Review LaterAdd Note

Review Later

List five benefits of a hosted data warehouse.

Correct Answer

verified

•Minimal investment in infrastructure
•...

View Answer

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

The ________ is a concession to the natural forces that undermine the best plans for developing a perfect system.It uses all possible means to integrate analytical resources from multiple sources to meet changing needs or business conditions.

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

The centralized data warehouse helps to simplify data management and administration.

It is important to identify the right level of ________ that will be needed during the scoping of a data warehouse project.A low level of that will result in more data being stored in the warehouse.

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?

A data warehouse contains ________ about how data are organized and how to use them effectively.

An independent data mart is a small warehouse designed for a strategic business unit (SBU)or a department whose source is an EDW.

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

An ________ is a large-scale data warehouse that is utilized across the enterprise for decision support.

A data warehouse differs from an operational database in that most data warehouses have a product orientation and are designed to handle transactions that update the database.

A data warehouse needs to support scalability,which pertains to 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.

During data modeling,expertise is required to determine what data are needed,define business rules associated with the data,and decide what ________ and other calculations may be necessary.

Describe various issues that affect whether an organization will purchase data transformation tools or build the transformation process itself.

List 5 factors that potentially affect the architecture selection decision.

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

________ is a small data warehouse designed for a strategic business unit (SBU)or a department.

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

ETL process consists of extract,transform,and load.Transformation occurs by using ________ or lookup s or by combining the data with other data.

Describe various integration technologies that enable data and metadata integration.