Question 1

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

Accepted Answer

Information

Question 2

A relational database contains information in a series of two-dimensional tables.How is data contained in a data warehouse and data mart?

Accepted Answer

A)  Information is multidimensional, meaning it contains a single layer of data in a table format. 
B)  Information is two-dimensional, meaning it contains a single layer of data in a table format. 
C)  Information is two-dimensional, meaning it contains layers of columns and rows. 
D)  Information is multidimensional, meaning it contains layers of columns and rows. 
A)  Information is multidimensional, meaning it contains a single layer of data in a table format. 
B)  Information is two-dimensional, meaning it contains a single layer of data in a table format. 
C)  Information is two-dimensional, meaning it contains layers of columns and rows. 
D)  Information is multidimensional, meaning it contains layers of columns and rows. D

Question 3

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

logical

Question 4

Which of the following can use BI to make informed decisions?

Accepted Answer

A)  Law enforcement industry 
B)  Airline industry 
C)  Broadcasting industry 
D)  All of these 
A)  Law enforcement industry 
B)  Airline industry 
C)  Broadcasting industry 
D)  All of these

Question 5

What is the primary problem most organizations face today concerning information?

Accepted Answer

A)  Business intelligence rich, information rich 
B)  Data poor, information rich 
C)  Business intelligence poor, information rich 
D)  Data rich, information poor 
A)  Business intelligence rich, information rich 
B)  Data poor, information rich 
C)  Business intelligence poor, information rich 
D)  Data rich, information poor

Question 6

Explain the primary difference between a database and a data warehouse.

Accepted Answer

The primary difference between a databas

Question 7

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

Accepted Answer

A)  Collecting information. 
B)  Discerning patterns and meaning in the information. 
C)  Accurate and complete information. 
D)  Responding to the resultant information. 
A)  Collecting information. 
B)  Discerning patterns and meaning in the information. 
C)  Accurate and complete information. 
D)  Responding to the resultant information.

Question 8

Data information in a data warehouse contains layers of columns and rows,and this is known as __________ databases.

Accepted Answer

The answer of Data information in a data warehouse contains...

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 why an organization cannot achieve 100 percent accurate and complete information.

Accepted Answer

Achieving perfect information is almost

Question 11

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

Accepted Answer

A)  Operational systems do 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)  Operational systems do 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 12

Explain the relationship between business intelligence and a data warehouse.

Accepted Answer

The purpose of a data warehous

Question 13

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.

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

Accepted Answer

A) True 
 B)False

Question 17

What do data warehouses support?

Accepted Answer

A)  OLAP 
B)  Analytical processing 
C)  OLTP 
D)  OLAP and analytical processing 
A)  OLAP 
B)  Analytical processing 
C)  OLTP 
D)  OLAP and analytical processing

Question 18

A(n)__________ is a particular attribute of information.

Accepted Answer

The answer of A(n)__________ is a particular attribute of information....

Question 19

Which of the following statements is true regarding customer information?

Accepted Answer

A)  Customer information can exist in several operational systems. 
B)  Customer information in each operational system could change. 
C)  Customer information in each operational system can be different. 
D)  All of these 
A)  Customer information can exist in several operational systems. 
B)  Customer information in each operational system could change. 
C)  Customer information in each operational system can be different. 
D)  All of these

Question 20

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.

Exam 8: Accessing Organizational Information-Data Warehouse

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

A relational database contains information in a series of two-dimensional tables.How is data contained in a data warehouse and data mart?

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

Which of the following can use BI to make informed decisions?

What is the primary problem most organizations face today concerning information?

Explain the primary difference between a database and a data warehouse.

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

Data information in a data warehouse contains layers of columns and rows,and this is known as __________ databases.

A data __________ contains a subset of data warehouse information.

Explain why an organization cannot achieve 100 percent accurate and complete information.

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

Explain the relationship between business intelligence and a data warehouse.

Why is Noodles & Company using business intelligence?

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

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

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

What do data warehouses support?

A(n)__________ is a particular attribute of information.

Which of the following statements is true regarding customer information?

Which of the following occurs during data cleansing?

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