Question 1

OLAP stands for ________.

Accepted Answer

A) online analytical processing 
B) object-based lead analysis procedure 
C) object-oriented analytical protocol 
D) organizational lead analysis process 
A) online analytical processing 
B) object-based lead analysis procedure 
C) object-oriented analytical protocol 
D) organizational lead analysis process

Question 2

Which of the following statements is true about data marts?

Accepted Answer

A) A data mart is like a distributor in a supply chain, while a data warehouse can be compared to a retail store. 
B) Data mart users possess the data management expertise that data warehouse employees have. 
C) Data marts address only a particular component or functional area of a business. 
D) Data marts are larger than data warehouses. 
A) A data mart is like a distributor in a supply chain, while a data warehouse can be compared to a retail store. 
B) Data mart users possess the data management expertise that data warehouse employees have. 
C) Data marts address only a particular component or functional area of a business. 
D) Data marts are larger than data warehouses.

Question 3

MapReduce is a technique for harnessing the power of thousands of computers working in parallel.

Accepted Answer

A) True 
 B)False

Question 4

KM fosters innovation by encouraging the free flow of ideas.

Accepted Answer

A) True 
 B)False

Question 5

What is a reporting application? Name five basic reporting operations.

Accepted Answer

A reporting application is a BI applicat

Question 6

Which of the following accurately defines a dimension in an OLAP report?

Accepted Answer

A) It is a characteristic of a measure. 
B) It is the item that is processed in the OLAP report. 
C) It is the data item of interest. 
D) It is referred to as a decision tree. 
A) It is a characteristic of a measure. 
B) It is the item that is processed in the OLAP report. 
C) It is the data item of interest. 
D) It is referred to as a decision tree.

Question 7

Which of the following statements is true about BI publishing alternatives?

Accepted Answer

A) Most dynamic reports are published as PDF documents. 
B) For Web servers and SharePoint, the push option is mandatory. 
C) BI servers extend alert/RSS functionality to support user subscriptions. 
D) Publishing static BI content requires more skill, compared to publishing dynamic BI content. 
A) Most dynamic reports are published as PDF documents. 
B) For Web servers and SharePoint, the push option is mandatory. 
C) BI servers extend alert/RSS functionality to support user subscriptions. 
D) Publishing static BI content requires more skill, compared to publishing dynamic BI content.

Question 8

________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction.

Accepted Answer

A) Data optimization 
B) Database normalization 
C) Data mining 
D) Data warehousing 
A) Data optimization 
B) Database normalization 
C) Data mining 
D) Data warehousing

Question 9

Problematic operational data are termed ________.

Accepted Answer

A) bad data 
B) rough data 
C) dirty data 
D) granular data 
A) bad data 
B) rough data 
C) dirty data 
D) granular data

Question 10

Which of the following is a basic operation used by reporting tools to produce information from data?

Accepted Answer

A) coalescing 
B) transposing 
C) dispersing 
D) calculating 
A) coalescing 
B) transposing 
C) dispersing 
D) calculating

Question 11

A data ________ is a data collection, smaller than the data warehouse, that addresses a particular department or functional area of the business.

Accepted Answer

A) mart 
B) mine 
C) cube 
D) model 
A) mart 
B) mine 
C) cube 
D) model

Question 12

Operational data is structured for fast and reliable transaction processing.

Accepted Answer

A) True 
 B)False

Question 13

________ are information systems that support the management and delivery of documents including reports, Web pages, and other expressions of employee knowledge.

Accepted Answer

A) Knowledge Discovery in Databases (KD
D)  
B) Online Analytical Processing (OLAP)applications 
C) Content Management Systems (CMS) 
D) Data Transfer Protocols (DTP) 
A) Knowledge Discovery in Databases (KD
D)  
B) Online Analytical Processing (OLAP)applications 
C) Content Management Systems (CMS) 
D) Data Transfer Protocols (DTP)

Question 14

In expert systems, the programs that process a set of rules are called expert systems shells.

Accepted Answer

A) True 
 B)False

Question 15

Cluster analysis is used to identify groups of entities that have similar characteristics.

Accepted Answer

A) True 
 B)False

Question 16

The ________ is the most popular BI server today.

Accepted Answer

A) Oracle BI Server 
B) Microsoft Windows Vista 
C) Microsoft SQL Server Report manager 
D) Pentaho BI Server 
A) Oracle BI Server 
B) Microsoft Windows Vista 
C) Microsoft SQL Server Report manager 
D) Pentaho BI Server

Question 17

In an OLAP report, a measure is the data item of interest.

Accepted Answer

A) True 
 B)False

Question 18

Data acquisition is the process of creating business intelligence.

Accepted Answer

A) True 
 B)False

Question 19

In marketing transactions, the fact that customers who buy product X also buy product Y creates a cross-selling opportunity.

Accepted Answer

A) True 
 B)False

Question 20

Because of the various problems with operational data, large organizations choose to extract operational data and store them into a(n)________.

Accepted Answer

A) OLAP cube 
B) neural network 
C) data warehouse 
D) Web server 
A) OLAP cube 
B) neural network 
C) data warehouse 
D) Web server

OLAP stands for ________.

Which of the following statements is true about data marts?

MapReduce is a technique for harnessing the power of thousands of computers working in parallel.

KM fosters innovation by encouraging the free flow of ideas.

What is a reporting application? Name five basic reporting operations.

Which of the following accurately defines a dimension in an OLAP report?

Which of the following statements is true about BI publishing alternatives?

________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction.

Problematic operational data are termed ________.

Which of the following is a basic operation used by reporting tools to produce information from data?

A data ________ is a data collection, smaller than the data warehouse, that addresses a particular department or functional area of the business.

Operational data is structured for fast and reliable transaction processing.

________ are information systems that support the management and delivery of documents including reports, Web pages, and other expressions of employee knowledge.

In expert systems, the programs that process a set of rules are called expert systems shells.

Cluster analysis is used to identify groups of entities that have similar characteristics.

The ________ is the most popular BI server today.

In an OLAP report, a measure is the data item of interest.

Data acquisition is the process of creating business intelligence.

In marketing transactions, the fact that customers who buy product X also buy product Y creates a cross-selling opportunity.

Because of the various problems with operational data, large organizations choose to extract operational data and store them into a(n)________.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Database Processing

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters

Exam 9: Business Intelligence Systems

OLAP stands for ________.

Which of the following statements is true about data marts?

MapReduce is a technique for harnessing the power of thousands of computers working in parallel.

KM fosters innovation by encouraging the free flow of ideas.

What is a reporting application? Name five basic reporting operations.

Which of the following accurately defines a dimension in an OLAP report?

Which of the following statements is true about BI publishing alternatives?

________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction.

Problematic operational data are termed ________.

Which of the following is a basic operation used by reporting tools to produce information from data?

A data ________ is a data collection, smaller than the data warehouse, that addresses a particular department or functional area of the business.

Operational data is structured for fast and reliable transaction processing.

________ are information systems that support the management and delivery of documents including reports, Web pages, and other expressions of employee knowledge.

In expert systems, the programs that process a set of rules are called expert systems shells.

Cluster analysis is used to identify groups of entities that have similar characteristics.

The ________ is the most popular BI server today.

In an OLAP report, a measure is the data item of interest.

Data acquisition is the process of creating business intelligence.

In marketing transactions, the fact that customers who buy product X also buy product Y creates a cross-selling opportunity.

Because of the various problems with operational data, large organizations choose to extract operational data and store them into a(n)________.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Database Processing

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters