Question 1

The ability to be proactive in identifying legal issues, thereby foregoing potential financial penalties that might impact a firm would be considered an intangible project benefit.

Accepted Answer

A) True 
 B)False

Question 2

Organizational culture can have an impact on their readiness to develop a data warehouse because data warehouse development implies cross departmental cooperation and information sharing.

Accepted Answer

A) True 
 B)False

Question 3

Define three levels of enterprise integration.

Accepted Answer

1) Horizontal integration ensures that e...

Question 4

One low cost approach to determining data warehouse feasibility is to develop a proof of concept.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is considered a key question to the success of a data warehouse initiative?

Accepted Answer

A)   What are the key performance indicators used for each of the key business initiatives?
B)   What is the potential impact on each of the existing performance metrics with improved access to higher-quality business process information?
C)   What does management consider to be the key strategic business initiatives?
D)   All of the above.E) B) and C)
F) None of the above

Question 6

____________ determines the point where the benefits of a project equal its costs.

Accepted Answer

A)   Net present value
B)   Breakeven analysis
C)   Internal rate of return
D)   All of the above.E) None of the above
F) A) and C)

Question 7

The enterprise model consists of a number of separate models integrated together to provide a comprehensive view of the organization.

Accepted Answer

A) True 
 B)False

Question 8

__________ ensures that there is consistent definition of data and processes across the organization.

Accepted Answer

A)   Horizontal integration
B)   Vertical integration
C)   Enterprise integration
D)   None of the above.E) C) and D)
F) None of the above

Question 9

Which of the following is not a tangible benefit?

Accepted Answer

A)   Increase in process quality
B)   Reduction in employee turnover
C)   Improving time to market
D)   Decreased need for travelE) B) and D)
F) B) and C)

Question 10

The corporate process model describes the entities generated by the elementary processes carried out by the enterprise.

Accepted Answer

A) True 
 B)False

Question 11

Joining a fact table to dimension tables in a star schema is referred to as a:

Accepted Answer

A)   star join.
B)   data mart.
C)   fact analysis.
D)   dimensional warehouse.E) A) and C)
F) A) and D)

Question 12

A top-down data warehouse design focuses on making use of data available in the current operational systems.

Accepted Answer

A) True 
 B)False  False

Question 13

Which economic feasibility measure results in a return on investment expressed as an interest rate?

Accepted Answer

A)   Net present value
B)   Breakeven analysis
C)   Internal rate of return
D)   All of the above.E) C) and D)
F) B) and C)

Question 14

List the guidelines for a successful data warehouse project.

Accepted Answer

1) Have a strong project sponsor
2) Gene...

Question 15

Which of the following refers to a perspective from which an argument to pursue an investment can be made?

Accepted Answer

A)   Faith
B)   Fear
C)   Facts
D)   All of the above.E) A) and B)
F) C) and D) D

Question 16

Which term refers to the process of developing a relatively low cost prototype to demonstrate that a data warehouse will achieve the perceived benefits?

Accepted Answer

A)   Proof of prototype
B)   Proof of concept
C)   Proof of benefit
D)   None of the above.E) B) and C)
F) A) and D)

Question 17

Which of the following is not an intangible benefit?

Accepted Answer

A)   Development of new markets
B)   Increased competitive advantage
C)   More timely information
D)   Increased workplace safetyE) B) and C)
F) B) and D)

Question 18

One common approach to data warehouse project prioritization is to rank initiatives by impact on the information technology organization.

Accepted Answer

A) True 
 B)False

Question 19

Enterprise integration ensures that each application is fully integrated within its own boundaries.

Accepted Answer

A) True 
 B)False

Question 20

A project benefit that can be identified with certainty and expressed in dollars is said to be an intangible benefit.

Accepted Answer

A) True 
 B)False  False

Exam 12: Designing and Building the Data Warehouse

The ability to be proactive in identifying legal issues, thereby foregoing potential financial penalties that might impact a firm would be considered an intangible project benefit.

Correct AnswerverifiedShow Answer

Organizational culture can have an impact on their readiness to develop a data warehouse because data warehouse development implies cross departmental cooperation and information sharing.

Correct AnswerverifiedShow Answer

Define three levels of enterprise integration.

Correct Answerverified1) Horizontal integration ensures that e...View AnswerShow Answer

One low cost approach to determining data warehouse feasibility is to develop a proof of concept.

Correct AnswerverifiedShow Answer

Which of the following is considered a key question to the success of a data warehouse initiative?

Correct AnswerverifiedShow Answer

____________ determines the point where the benefits of a project equal its costs.

Correct AnswerverifiedShow Answer

The enterprise model consists of a number of separate models integrated together to provide a comprehensive view of the organization.

Correct AnswerverifiedShow Answer

__________ ensures that there is consistent definition of data and processes across the organization.

Correct AnswerverifiedShow Answer

Which of the following is not a tangible benefit?

Correct AnswerverifiedShow Answer

The corporate process model describes the entities generated by the elementary processes carried out by the enterprise.

Correct AnswerverifiedShow Answer

Joining a fact table to dimension tables in a star schema is referred to as a:

Correct AnswerverifiedShow Answer

A top-down data warehouse design focuses on making use of data available in the current operational systems.

Correct AnswerverifiedFalse

Which economic feasibility measure results in a return on investment expressed as an interest rate?

Correct AnswerverifiedShow Answer

List the guidelines for a successful data warehouse project.

Correct Answerverified1) Have a strong project sponsor2) Gene...View AnswerShow Answer

Which of the following refers to a perspective from which an argument to pursue an investment can be made?

Correct AnswerverifiedD

Which term refers to the process of developing a relatively low cost prototype to demonstrate that a data warehouse will achieve the perceived benefits?

Correct AnswerverifiedShow Answer

Which of the following is not an intangible benefit?

Correct AnswerverifiedShow Answer

One common approach to data warehouse project prioritization is to rank initiatives by impact on the information technology organization.

Correct AnswerverifiedShow Answer

Enterprise integration ensures that each application is fully integrated within its own boundaries.

Correct AnswerverifiedShow Answer

A project benefit that can be identified with certainty and expressed in dollars is said to be an intangible benefit.

Correct AnswerverifiedFalse

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
1) Horizontal integration ensures that e...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified
1) Have a strong project sponsor
2) Gene...
View Answer

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False