Question 1

Identify the importance of ensuring the cleanliness of information throughout an organization.

Accepted Answer

An organization must maintain high-quali

Question 2

A(n)___________ is the common term for the representation of multidimensional information.

Accepted Answer

The answer of A(n)___________ is the common term for the...

Question 3

What types of BI decisions include forecasting claim amounts and medical coverage costs,classifying the most important elements that affect medical coverage; predicting which customers will buy new insurance policies?

Accepted Answer

A)  Retail and sales BI decisions 
B)  Banking BI decisions 
C)  Operations management BI decisions 
D)  Insurance BI decisions 
A)  Retail and sales BI decisions 
B)  Banking BI decisions 
C)  Operations management BI decisions 
D)  Insurance BI decisions

Question 4

Lands' End created an organization-wide data warehouse so all its employees could access organizational information.Lands' End soon found out that there could be "too much of a good thing." Many of its employees would not use the data warehouse,because it was simply too big,too complicated,and had too much irrelevant information.Lands' End knew there was valuable information in its data warehouse,and it had to find a way for its employees to easily access the information.What was Lands' End's solution?

Accepted Answer

A)  Build a better, more efficient data warehouse. 
B)  Build a better, more efficient transactional database. 
C)  Build a data mart. 
D)  Build a data-driven website. 
A)  Build a better, more efficient data warehouse. 
B)  Build a better, more efficient transactional database. 
C)  Build a data mart. 
D)  Build a data-driven website.

Question 5

What types of BI decisions include forecasting levels of bad loans and fraudulent credit card use,credit card spending by new customers,and which kinds of customers will best respond to new loan offers?

Accepted Answer

A)  Retail and sales BI decisions 
B)  Banking BI decisions 
C)  Operations management BI decisions 
D)  Insurance BI decisions 
A)  Retail and sales BI decisions 
B)  Banking BI decisions 
C)  Operations management BI decisions 
D)  Insurance BI decisions

Question 6

Why would a business use a data warehouse that offers strategic level,external,integrated,and historical information?

Accepted Answer

A)  Identify trends. 
B)  Make projections. 
C)  Decide key business issues. 
D)  All of these. 
A)  Identify trends. 
B)  Make projections. 
C)  Decide key business issues. 
D)  All of these.

Question 7

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 8

What is a dimension?

Accepted Answer

A)  A particular attribute of information. 
B)  A particular entity of information. 
C)  A particular relational database. 
D)  A particular single repository. 
A)  A particular attribute of information. 
B)  A particular entity of information. 
C)  A particular relational database. 
D)  A particular single repository.

Question 9

_____________ 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 10

The Data Warehousing Institute estimates that low-quality information costs U.S.businesses $60 billion annually.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Explain the problem associated with business intelligence.Describe the solution to this business problem.

Accepted Answer

The issue most organizations are facing

Question 13

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

The answer of Data _________ is the process of analyzing...

Question 14

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

A) True 
 B)False

Question 15

A dimension is a particular attribute of information.

Accepted Answer

A) True 
 B)False

Question 16

A dimension is a particular attribute of information.Each layer in a data warehouse or data mart represents information according to an additional dimension.What is the common term for the representation of multidimensional information?

Accepted Answer

A)  Table 
B)  Block 
C)  Cube 
D)  All of these 
A)  Table 
B)  Block 
C)  Cube 
D)  All of these

Question 17

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 18

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 19

What types of BI decisions include predicting sales,determining correct inventory levels,and distribution schedules among outlets,and loss prevention?

Accepted Answer

A)  Retail and sales BI decisions 
B)  Banking BI decisions 
C)  Operations management BI decisions 
D)  Insurance BI decisions 
A)  Retail and sales BI decisions 
B)  Banking BI decisions 
C)  Operations management BI decisions 
D)  Insurance BI decisions

Question 20

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.

Exam 8: Accessing Organizational Information-Data Warehouse

Identify the importance of ensuring the cleanliness of information throughout an organization.

A(n)___________ is the common term for the representation of multidimensional information.

What types of BI decisions include forecasting claim amounts and medical coverage costs,classifying the most important elements that affect medical coverage; predicting which customers will buy new insurance policies?

What types of BI decisions include forecasting levels of bad loans and fraudulent credit card use,credit card spending by new customers,and which kinds of customers will best respond to new loan offers?

Why would a business use a data warehouse that offers strategic level,external,integrated,and historical information?

Which of the following describes ETL?

What is a dimension?

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

The Data Warehousing Institute estimates that low-quality information costs U.S.businesses $60 billion annually.

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

Explain the problem associated with business intelligence.Describe the solution to this business problem.

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

The primary purpose of a data warehouse is to perform transactional processes.

A dimension is a particular attribute of information.

A dimension is a particular attribute of information.Each layer in a data warehouse or data mart represents information according to an additional dimension.What is the common term for the representation of multidimensional information?

When does information cleansing occur in the data warehouse?

What is the primary purpose of a data warehouse?

What types of BI decisions include predicting sales,determining correct inventory levels,and distribution schedules among outlets,and loss prevention?

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?

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

Ebusiness

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

Developing a 21st-Century Organization

Business Basics

Business Process

Hardware and Software Basics

Mis Infrastructures

Networks and Telecommunications

Information Security

Ethics

Operations Management

Sustainable Mis Infrastructures

Business Intelligence

Global Information Systems

Global Trends

Filters