Question 1

Which of the following is a problem associated with dirty data?

Accepted Answer

A) Duplicate data 
B) Incorrect data 
C) Violates business rules 
D) All of these 
A) Duplicate data 
B) Incorrect data 
C) Violates business rules 
D) All of these

Question 2

How would the insurance industry use business intelligence?

Accepted Answer

A) Analyze popular vacation locations with current flight listings. 
B) Understand customer credit card usage and nonpayment rates. 
C) Compare the demographics of patients with critical illnesses. 
D) Predict claim amounts and medical coverage costs. 
A) Analyze popular vacation locations with current flight listings. 
B) Understand customer credit card usage and nonpayment rates. 
C) Compare the demographics of patients with critical illnesses. 
D) Predict claim amounts and medical coverage costs.

Question 3

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

Accepted Answer

A) True 
 B)False

Question 4

What is source data?

Accepted Answer

A) Identifies the primary location where data is collected. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data. 
A) Identifies the primary location where data is collected. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data.

Question 5

What is a central location in which data is stored and managed?

Accepted Answer

A) Repository 
B) Data warehouse 
C) Data aggregation 
D) Data broker 
A) Repository 
B) Data warehouse 
C) Data aggregation 
D) Data broker

Question 6

What is a data broker?

Accepted Answer

A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data. 
A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data.

Question 7

A data mart contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 8

Define a data warehouse and provide a few reasons it can make a manager more effective.

Accepted Answer

A data warehouse is a logical collection

Question 9

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business has been?

Accepted Answer

A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of these. 
A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of these.

Question 10

Business intelligence can provide managers with the ability to make better decisions.Which of the following is not an example of how different industries use business intelligence?

Accepted Answer

A) Predict claim amounts and medical coverage costs. 
B) Track crime patterns, locations, and criminal behavior. 
C) Identify the primary locations where data is collected. 
D) Predict sales, inventory levels, and distribution. 
A) Predict claim amounts and medical coverage costs. 
B) Track crime patterns, locations, and criminal behavior. 
C) Identify the primary locations where data is collected. 
D) Predict sales, inventory levels, and distribution.

Question 11

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

A) True 
 B)False

Question 12

Companies can choose information cleansing software from several vendors.Which of the following is not a vendor mentioned in your text?

Accepted Answer

A) Oracle. 
B) SAS. 
C) Ascential Software. 
D) McAffee. 
A) Oracle. 
B) SAS. 
C) Ascential Software. 
D) McAffee.

Question 13

Which of the following questions is an example of how managers can use BI to answer tough business questions?

Accepted Answer

A) Where has the business been? 
B) Where is the business now? 
C) Where is the business going? 
D) All of these. 
A) Where has the business been? 
B) Where is the business now? 
C) Where is the business going? 
D) All of these.

Question 14

Comparative analysis can help managers with competitive monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

Accepted Answer

A) True 
 B)False

Question 15

Why were data warehouses created?

Accepted Answer

A) Numbers and types of operational databases increased as businesses grew. 
B) Many companies had information scattered across multiple systems with different formats. 
C) Completing reporting requests from numerous operational systems took days or weeks. 
D) All of these. 
A) Numbers and types of operational databases increased as businesses grew. 
B) Many companies had information scattered across multiple systems with different formats. 
C) Completing reporting requests from numerous operational systems took days or weeks. 
D) All of these.

Question 16

Which of the following is a problem associated with dirty data?

Accepted Answer

A) Inaccurate data 
B) Misleading data 
C) Non formatted data 
D) All of these 
A) Inaccurate data 
B) Misleading data 
C) Non formatted data 
D) All of these

Question 17

ETL, within a data warehouse model, stands for exit, track, and load.

Accepted Answer

A) True 
 B)False

Question 18

A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following questions can be answered using business intelligence?

Accepted Answer

A) Where has the business been? 
B) Where is the business now? 
C) Where is the business going? 
D) All of these. 
A) Where has the business been? 
B) Where is the business now? 
C) Where is the business going? 
D) All of these.

Question 20

What is extraction, transformation, and loading?

Accepted Answer

A) It is a process of entering data, tracking data, and loading it into a database 
B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse 
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube 
D) It is a process that is performed at the beginning of the data mining model 
A) It is a process of entering data, tracking data, and loading it into a database 
B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse 
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube 
D) It is a process that is performed at the beginning of the data mining model

Exam 7: Accessing Organizational Information Data Warehouses

Which of the following is a problem associated with dirty data?

How would the insurance industry use business intelligence?

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

What is source data?

What is a central location in which data is stored and managed?

What is a data broker?

A data mart contains a subset of data warehouse information.

Define a data warehouse and provide a few reasons it can make a manager more effective.

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business has been?

Business intelligence can provide managers with the ability to make better decisions.Which of the following is not an example of how different industries use business intelligence?

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Companies can choose information cleansing software from several vendors.Which of the following is not a vendor mentioned in your text?

Which of the following questions is an example of how managers can use BI to answer tough business questions?

Comparative analysis can help managers with competitive monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

Why were data warehouses created?

Which of the following is a problem associated with dirty data?

ETL, within a data warehouse model, stands for exit, track, and load.

A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

Which of the following questions can be answered using business intelligence?

What is extraction, transformation, and loading?

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 and Storing Organizational Information Databases

Understanding Big Data and Its Impact on Business

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

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

B: Extension: A Business Basics

B: Extension: A Business Process

B: Extension: A Hardware and Software Basics

B: Extension: A Mis Infrastructures

B: Extension: A Networks and Telecommunications

B: Extension: A Information Security

B: Extension: A Ethics

B: Extension: A Operations Management

B: Extension: A Sustainable Mis Infrastructures

B: Extension: A Business Intelligence

B: Extension: A Global Information Systems

B: Extension: A Global Trends

Filters