Question 1

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 2

How would the airline 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

Which of the following is not a dirty data problem?

Accepted Answer

A) Duplicate data. 
B) Inaccurate data. 
C) Specific data. 
D) Nonintegrated data. 
A) Duplicate data. 
B) Inaccurate data. 
C) Specific data. 
D) Nonintegrated data.

Question 4

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

Accepted Answer

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

Question 5

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _________ productivity rates and ____________ profits.

Accepted Answer

A) 4% lower, 6% higher 
B) 4% higher, 6% lower 
C) 4% higher, 6% higher 
D) 4% lower, 6% lower 
A) 4% lower, 6% higher 
B) 4% higher, 6% lower 
C) 4% higher, 6% higher 
D) 4% lower, 6% lower

Question 6

Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

Accepted Answer

A) Comparative analysis. 
B) Competitive monitoring. 
C) Data-driven decision management. 
D) Source data. 
A) Comparative analysis. 
B) Competitive monitoring. 
C) Data-driven decision management. 
D) Source data.

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A data point is an individual item on a graph or chart.

Accepted Answer

A) True 
 B)False

Question 9

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Accepted Answer

A) True 
 B)False

Question 10

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 11

Source data identifies the primary location where data is collected.It can include invoices, spreadsheets, timesheets, transactions, and electronic sources such as other databases.

Accepted Answer

A) True 
 B)False

Question 12

What is a collection of data from various sources for the purpose of data processing?

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 13

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) 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) All of these are examples of how industries use business intelligence. 
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) All of these are examples of how industries use business intelligence.

Question 14

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

Accepted Answer

A) True 
 B)False

Question 15

What is erroneous or flawed data?

Accepted Answer

A) Data set. 
B) Dirty data. 
C) Data map. 
D) Data point. 
A) Data set. 
B) Dirty data. 
C) Data map. 
D) Data point.

Question 16

A data set is an individual item on a graph or chart.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following identifies the primary location where data is collected?

Accepted Answer

A) Comparative analysis. 
B) Competitive monitoring. 
C) Data-driven decision management. 
D) Source data. 
A) Comparative analysis. 
B) Competitive monitoring. 
C) Data-driven decision management. 
D) Source data.

Question 18

Business analysis is difficult from operational databases.Which of the following is a reason why?

Accepted Answer

A) Every department has its own method for recording data. 
B) Data standards do not apply across departments. 
C) The data, if available, were often incorrect or incomplete. 
D) All of these. 
A) Every department has its own method for recording data. 
B) Data standards do not apply across departments. 
C) The data, if available, were often incorrect or incomplete. 
D) All of these.

Question 19

A data broker is an individual item on a graph or a chart.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) Data broker 
B) Data lake 
C) Data map 
D) Data point 
A) Data broker 
B) Data lake 
C) Data map 
D) Data point

Exam 7: Accessing Organizational Information Data Warehouses

What do data warehouses support?

How would the airline industry use business intelligence?

Which of the following is not a dirty data problem?

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

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _________ productivity rates and ____________ profits.

Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

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

A data point is an individual item on a graph or chart.

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Which of the following statements is true regarding customer information?

Source data identifies the primary location where data is collected.It can include invoices, spreadsheets, timesheets, transactions, and electronic sources such as other databases.

What is a collection of data from various sources for the purpose of data processing?

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?

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

What is erroneous or flawed data?

A data set is an individual item on a graph or chart.

Which of the following identifies the primary location where data is collected?

Business analysis is difficult from operational databases.Which of the following is a reason why?

A data broker is an individual item on a graph or a chart.

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

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

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _ productivity rates and ____ profits.