Question 1

Describe a star schema.

Accepted Answer

Data warehouse design is based upon the concept of dimensional modeling. The dimensional model is implemented with a star schema. The star schema is the means by which dimensional modeling is implemented. A star schema contains a central fact table. A fact table contains the attributes needed to perform decision analysis, descriptive attributes used for query reporting, and foreign keys to link to dimension tables. The fact tables describe what data can be analyzed; dimension tables describe how data can be analyzed.

Question 2

________ is a critical aspect of data warehousing that includes reconciling conflicting data definitions and formats organization-wide.

Accepted Answer

A)  Data modification 
B)  Fact refinement 
C)  Data purification 
D)  Data cleansing 
A)  Data modification 
B)  Fact refinement 
C)  Data purification 
D)  Data cleansing D

Question 3

Which of the following is not one of the failure factors in data warehousing?

Accepted Answer

A)  Cultural issues are ignored. 
B)  inappropriate architecture 
C)  unrealistic expectations 
D)  high levels of data summarization 
A)  Cultural issues are ignored. 
B)  inappropriate architecture 
C)  unrealistic expectations 
D)  high levels of data summarization D

Question 4

The high cost of data warehouses limits their use to large companies. As an alternative, many firms use a lower-cost, scaled-down version of a data warehouse referred to as (an) ________.

Accepted Answer

A)  data mart 
B)  operational data store 
C)  dependent data mart 
D)  independent data mart 
A)  data mart 
B)  operational data store 
C)  dependent data mart 
D)  independent data mart

Question 5

Karacsony indicates that there is a direct correlation between the extent of ________ data and the amount of ETL processes. When data are managed correctly as an enterprise asset, ETL efforts are significantly reduced.

Accepted Answer

A)  enormous 
B)  bad 
C)  redundant 
D)  wrong 
A)  enormous 
B)  bad 
C)  redundant 
D)  wrong

Question 6

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

Independen

Question 10

A hosted data warehouse has less functionality than an onsite data warehouse, but it does not consume computer resources on client premises for computer upgrades, software licenses, in-house development, and in-house support and maintenance.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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 13

The data for an oper mart come from an ODS.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

Real-time data wareh

Question 15

Which of the following are created when operational data need to be analyzed multidimensionally?

Accepted Answer

A)  Oper marts 
B)  Customer information file 
C)  Dependent data marts 
D)  Independent data marts 
A)  Oper marts 
B)  Customer information file 
C)  Dependent data marts 
D)  Independent data marts

Question 16

Which of the following is not a data source to a data warehouse?

Accepted Answer

A)  ERP 
B)  Legacy 
C)  POS 
D)  ETL 
A)  ERP 
B)  Legacy 
C)  POS 
D)  ETL

Question 17

Data warehouse is a(n) ________, integrated, time-variant, nonvolatile collection of data in support of management's decision making process.

Accepted Answer

A)  analysis-oriented 
B)  object-oriented 
C)  subject-oriented 
D)  model-oriented 
A)  analysis-oriented 
B)  object-oriented 
C)  subject-oriented 
D)  model-oriented

Question 18

When DirectTV decided to implement an active data warehouse solution, the goal of the new system was to send fresh data to the call center at least daily. Once the capabilities of the solutions became apparent, that goal:

Accepted Answer

A)  dropped to fresh data of less than 15 minutes to improve responsiveness. 
B)  dropped to fresh data every 12 hours to improve responsiveness. 
C)  increased to every 2 days to reduce maintenance costs. 
D)  increased to every 5 days to reduce maintenance costs. 
A)  dropped to fresh data of less than 15 minutes to improve responsiveness. 
B)  dropped to fresh data every 12 hours to improve responsiveness. 
C)  increased to every 2 days to reduce maintenance costs. 
D)  increased to every 5 days to reduce maintenance costs.

Question 19

The ________ have inconsistent data definitions and different dimensions and measures, making it difficult to analyze data across those marts.

Accepted Answer

A)  enterprise data marts 
B)  operational data marts 
C)  dependent data marts 
D)  independent data marts 
A)  enterprise data marts 
B)  operational data marts 
C)  dependent data marts 
D)  independent data marts

Question 20

According to conventional wisdom, independent data marts are a poor architectural solution.

Accepted Answer

A) True 
 B)False

Describe a star schema.

________ is a critical aspect of data warehousing that includes reconciling conflicting data definitions and formats organization-wide.

Which of the following is not one of the failure factors in data warehousing?

The high cost of data warehouses limits their use to large companies. As an alternative, many firms use a lower-cost, scaled-down version of a data warehouse referred to as (an) ________.

Karacsony indicates that there is a direct correlation between the extent of ________ data and the amount of ETL processes. When data are managed correctly as an enterprise asset, ETL efforts are significantly reduced.

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.

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

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.

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

A hosted data warehouse has less functionality than an onsite data warehouse, but it does not consume computer resources on client premises for computer upgrades, software licenses, in-house development, and in-house support and maintenance.

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

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.

The data for an oper mart come from an ODS.

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

Which of the following are created when operational data need to be analyzed multidimensionally?

Which of the following is not a data source to a data warehouse?

Data warehouse is a(n) ________, integrated, time-variant, nonvolatile collection of data in support of management's decision making process.

When DirectTV decided to implement an active data warehouse solution, the goal of the new system was to send fresh data to the call center at least daily. Once the capabilities of the solutions became apparent, that goal:

The ________ have inconsistent data definitions and different dimensions and measures, making it difficult to analyze data across those marts.

According to conventional wisdom, independent data marts are a poor architectural solution.

Business Intelligence

Business Performance Management

Data Mining for Business Intelligence

Text and Web Mining

Business Intelligence Implementation: Integration and Emerging Trends

Filters

Exam 2: Data Warehousing

Describe a star schema.

________ is a critical aspect of data warehousing that includes reconciling conflicting data definitions and formats organization-wide.

Which of the following is not one of the failure factors in data warehousing?

The high cost of data warehouses limits their use to large companies. As an alternative, many firms use a lower-cost, scaled-down version of a data warehouse referred to as (an) ________.

Karacsony indicates that there is a direct correlation between the extent of ________ data and the amount of ETL processes. When data are managed correctly as an enterprise asset, ETL efforts are significantly reduced.

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.

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

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.

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

A hosted data warehouse has less functionality than an onsite data warehouse, but it does not consume computer resources on client premises for computer upgrades, software licenses, in-house development, and in-house support and maintenance.

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

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.

The data for an oper mart come from an ODS.

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

Which of the following are created when operational data need to be analyzed multidimensionally?

Which of the following is not a data source to a data warehouse?

Data warehouse is a(n) ________, integrated, time-variant, nonvolatile collection of data in support of management's decision making process.

When DirectTV decided to implement an active data warehouse solution, the goal of the new system was to send fresh data to the call center at least daily. Once the capabilities of the solutions became apparent, that goal:

The ________ have inconsistent data definitions and different dimensions and measures, making it difficult to analyze data across those marts.

According to conventional wisdom, independent data marts are a poor architectural solution.

Business Intelligence

Business Performance Management

Data Mining for Business Intelligence

Text and Web Mining

Business Intelligence Implementation: Integration and Emerging Trends

Filters