Question 1

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

Accepted Answer

The answer of ________ comprises three major processes that,when correctly...

Question 2

A(n)________ contains the attributes needed to perform decision analysis,descriptive attributes used for query reporting,and foreign keys to link to dimension s.

Accepted Answer

The answer of A(n)________ contains the attributes needed to perform...

Question 3

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.

Accepted Answer

The answer of It is important to identify the right...

Question 4

EII (enterprise information integration)tools use predefined metadata to populate views that make integrated data appear relational to end-users.________ may be the most important aspect of EII,because it allows data to be tagged either at the time of creation or later.

Accepted Answer

The answer of EII (enterprise information integration)tools use predefined metadata...

Question 5

One of the benefits of a well-designed data warehouse is that business rules can be stored in a ________ repository and applied to the data warehouse centrally.

Accepted Answer

The answer of One of the benefits of a well-designed...

Question 6

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

Accepted Answer

The answer of The ________ is a scaled-down version of...

Question 7

________ provides a fairly recent form of customer information files (CIF).It is a type of database often used as an interim staging area for a data warehouse.

Accepted Answer

The answer of ________ provides a fairly recent form of...

Question 8

A(n)________ data warehouse has nearly the same,if not more,functionality as an on-site data warehouse,but it does not consume computer resources on client premises.

Accepted Answer

The answer of A(n)________ data warehouse has nearly the same,if...

Question 9

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.

Accepted Answer

The answer of Data often are fragmented in distinct operational...

Question 10

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

Accepted Answer

The answer of The data warehouse design is based upon...

Question 11

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.

Accepted Answer

The answer of The main issues pertaining to ________ are...

Question 12

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

Accepted Answer

The answer of ________ is the process of loading and...

Question 13

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.

Accepted Answer

The answer of A data warehouse contains numerous ________ that...

Question 14

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

Accepted Answer

The answer of An ________ is a large-scale data warehouse...

Question 15

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

Accepted Answer

The answer of ________ is a subset that is created...

Question 16

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.

Accepted Answer

The answer of In three-tier architecture for data warehouse,________ contain...

Question 17

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

Accepted Answer

The answer of ________ is the person responsible for the...

Question 18

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.

Accepted Answer

The answer of The ________ is a concession to the...

Question 19

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

Accepted Answer

The answer of ________ is a small data warehouse designed...

Question 20

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.

Accepted Answer

The answer of During data modeling,expertise is required to determine...

Quiz 8: Data Warehousing