Question 1

What does the Data Warehousing Institute estimate that low-quality information costs U.S.businesses annually?

Accepted Answer

A)  $500 million. 
B)  $60 billion. 
C)  $600 billion. 
D)  It is impossible to determine. 
A)  $500 million. 
B)  $60 billion. 
C)  $600 billion. 
D)  It is impossible to determine.

Question 2

What is the primary purpose of a data warehouse?

Accepted Answer

A)  To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities. 
B)  To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities. 
C)  To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities. 
D)  To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities. 
A)  To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities. 
B)  To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities. 
C)  To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities. 
D)  To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.

Question 3

What is data mining?

Accepted Answer

A)  The common term for the representation of multidimensional information. 
B)  A particular attribute of information. 
C)  Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making. 
D)  Process of analyzing data to extract information not offered by the raw data alone. 
A)  The common term for the representation of multidimensional information. 
B)  A particular attribute of information. 
C)  Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making. 
D)  Process of analyzing data to extract information not offered by the raw data alone.

Question 4

Explain the relationship between business intelligence and a data warehouse.

Accepted Answer

A data warehouse is an enabler of busine

Question 5

Which of the following describes ETL?

Accepted Answer

A)  A process that extracts information from internal and external databases. 
B)  A process that transforms information using a common set of enterprise definitions. 
C)  A process that loads information into a data warehouse. 
D)  All of these. 
A)  A process that extracts information from internal and external databases. 
B)  A process that transforms information using a common set of enterprise definitions. 
C)  A process that loads information into a data warehouse. 
D)  All of these.

Question 6

When does information cleansing occur in the data warehouse?

Accepted Answer

A)  During the ETL process. 
B)  On the information, once it is in the data warehouse. 
C)  During the ETL process and once it is in the data warehouse. 
D)  During the ETL process and before it is in the data warehouse. 
A)  During the ETL process. 
B)  On the information, once it is in the data warehouse. 
C)  During the ETL process and once it is in the data warehouse. 
D)  During the ETL process and before it is in the data warehouse.

Question 7

Which of the following occurs during data cleansing?

Accepted Answer

A)  Clean missing records. 
B)  Clean redundant records. 
C)  Clean inaccurate data. 
D)  All of these. 
A)  Clean missing records. 
B)  Clean redundant records. 
C)  Clean inaccurate data. 
D)  All of these.

Question 8

Achieving perfect information is almost impossible.The more complete and accurate an organization wants its information to be,the more it costs.Which two variables are used to determine the trade-off for perfect information?

Accepted Answer

A)  Accuracy versus completeness. 
B)  Accessibility versus completeness. 
C)  Accuracy versus complexity. 
D)  Accessibility versus complexity. 
A)  Accuracy versus completeness. 
B)  Accessibility versus completeness. 
C)  Accuracy versus complexity. 
D)  Accessibility versus complexity.

Question 9

A data __________ contains a subset of data warehouse information.

Accepted Answer

The answer of A data __________ contains a subset of...

Question 10

Explain the multidimensional nature of data warehouses (and data marts)and the business value gained from multidimensional analysis.

Accepted Answer

Databases contain information in a serie

Question 11

A dimension is a particular attribute of information.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following are the principle BI enablers?

Accepted Answer

A)  Technology, processes, and customer culture 
B)  Technology, people, and customer culture 
C)  Technology, processes, and corporate culture 
D)  Technology, people, and corporate culture 
A)  Technology, processes, and customer culture 
B)  Technology, people, and customer culture 
C)  Technology, processes, and corporate culture 
D)  Technology, people, and corporate culture

Question 13

Which of the following statements is true?

Accepted Answer

A)  The more complete an organization wants to get its information, the less it costs. 
B)  The more accurate an organization wants to get its information, the less it costs. 
C)  The less accurate an organization wants to get its information, the more it costs. 
D)  The more complete and accurate an organization wants to get its information, the more it costs. 
A)  The more complete an organization wants to get its information, the less it costs. 
B)  The more accurate an organization wants to get its information, the less it costs. 
C)  The less accurate an organization wants to get its information, the more it costs. 
D)  The more complete and accurate an organization wants to get its information, the more it costs.

Question 14

Why is Ben & Jerry's using business intelligence?

Accepted Answer

A)  To improve quality. 
B)  To create new flavors of ice cream. 
C)  To improve financials. 
D)  To manage distribution. 
A)  To improve quality. 
B)  To create new flavors of ice cream. 
C)  To improve financials. 
D)  To manage distribution.

Question 15

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information.

Accepted Answer

The answer of _____________ cleansing or scrubbing is the process...

Question 16

All of the following are reasons why operational systems are not appropriate for business analysis except:

Accepted Answer

A)  Does not include information from other operational applications. 
B)  Operational systems are integrated. 
C)  Operational information is mainly current. 
D)  Operational information frequently has quality issues. 
A)  Does not include information from other operational applications. 
B)  Operational systems are integrated. 
C)  Operational information is mainly current. 
D)  Operational information frequently has quality issues.

Question 17

A data warehouse is a ___________ collection of information gathered from many different operational databases that supports business-analysis activities and decision-making tasks.

Accepted Answer

The answer of A data warehouse is a ___________ collection...

Question 18

Data warehousing is about extending the transformation of data into _________.

Accepted Answer

The answer of Data warehousing is about extending the transformation...

Question 19

The data warehouse is a location for all of a business's information.

Accepted Answer

A) True 
 B)False

Question 20

Why is Noodles & Company using business intelligence?

Accepted Answer

A)  To improve financial analysis. 
B)  To improve corporate processes. 
C)  To track store quality. 
D)  To change the corporate culture. 
A)  To improve financial analysis. 
B)  To improve corporate processes. 
C)  To track store quality. 
D)  To change the corporate culture.

What does the Data Warehousing Institute estimate that low-quality information costs U.S.businesses annually?

What is the primary purpose of a data warehouse?

What is data mining?

Explain the relationship between business intelligence and a data warehouse.

Which of the following describes ETL?

When does information cleansing occur in the data warehouse?

Which of the following occurs during data cleansing?

Achieving perfect information is almost impossible.The more complete and accurate an organization wants its information to be,the more it costs.Which two variables are used to determine the trade-off for perfect information?

A data __________ contains a subset of data warehouse information.

Explain the multidimensional nature of data warehouses (and data marts)and the business value gained from multidimensional analysis.

A dimension is a particular attribute of information.

Which of the following are the principle BI enablers?

Which of the following statements is true?

Why is Ben & Jerry's using business intelligence?

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information.

All of the following are reasons why operational systems are not appropriate for business analysis except:

A data warehouse is a ___________ collection of information gathered from many different operational databases that supports business-analysis activities and decision-making tasks.

Data warehousing is about extending the transformation of data into _________.

The data warehouse is a location for all of a business's information.

Why is Noodles & Company using business intelligence?

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing Organizational Information

Storing Organizational Information Databases

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End-To-End Enterprise Resource Planning

Creating Innovative Organizations

E-Business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Building Software to Support an Agile Organization

Managing Organizational Projects

Outsourcing in the 21st Century

Developing a 21st-Century Organization

Filters

Exam 8: Accessing Organizational Information Data Warehouse

What does the Data Warehousing Institute estimate that low-quality information costs U.S.businesses annually?

What is the primary purpose of a data warehouse?

What is data mining?

Explain the relationship between business intelligence and a data warehouse.

Which of the following describes ETL?

When does information cleansing occur in the data warehouse?

Which of the following occurs during data cleansing?

Achieving perfect information is almost impossible.The more complete and accurate an organization wants its information to be,the more it costs.Which two variables are used to determine the trade-off for perfect information?

A data __________ contains a subset of data warehouse information.

Explain the multidimensional nature of data warehouses (and data marts)and the business value gained from multidimensional analysis.

A dimension is a particular attribute of information.

Which of the following are the principle BI enablers?

Which of the following statements is true?

Why is Ben & Jerry's using business intelligence?

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information.

All of the following are reasons why operational systems are not appropriate for business analysis except:

A data warehouse is a ___________ collection of information gathered from many different operational databases that supports business-analysis activities and decision-making tasks.

Data warehousing is about extending the transformation of data into _________.

The data warehouse is a location for all of a business's information.

Why is Noodles & Company using business intelligence?

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing Organizational Information

Storing Organizational Information Databases

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End-To-End Enterprise Resource Planning

Creating Innovative Organizations

E-Business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Building Software to Support an Agile Organization

Managing Organizational Projects

Outsourcing in the 21st Century

Developing a 21st-Century Organization

Filters