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 processE) None of the above
F) All of the above

Question 2

Which of the following techniques determine sales patterns?

Accepted Answer

A)   regression analysis
B)   market-basket analysis
C)   neural networks
D)   cluster analysisE) All of the above
F) B) and C)

Question 3

Which of the following observations about RFM and OLAP reports is True?

Accepted Answer

A)   RFM reports are more generic than OLAP reports.
B)   OLAP reports are more dynamic than RFM reports.
C)   RFM reports have measures and dimensions.
D)   RFM reports can drill down into the data to a greater extent than OLAP reports.E) B) and C)
F) None of the above

Question 4

A ________ is a hierarchical arrangement of criteria that predict a classification or a value.

Accepted Answer

A)   value chain
B)   cluster analysis
C)   decision tree
D)   neural networkE) A) and B)
F) B) and C)

Question 5

The defining characteristic of OLAP reports is that they are dynamic.

Accepted Answer

A) True 
 B)False

Question 6

Describe the management functions of business intelligence (BI) server.

Accepted Answer

Business intelligence servers provide tw...

Question 7

A data mart is larger than a data warehouse.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A reporting application is a BI applicat...

Question 9

It is better to have data with too coarse a granularity than too fine.

Accepted Answer

A) True 
 B)False

Question 10

OLAP provides the ability to sum, count, average, and perform other simple arithmetic operations on groups of data.

Accepted Answer

A) True 
 B)False

Question 11

In marketing transactions, the fact that customers who buy product X also buy product Y creates a ________ opportunity. That is, "If they're buying X, sell them Y" or "If they're buying Y, sell them X."

Accepted Answer

A)   cross-selling
B)   value added selling
C)   break-even
D)   double-salesE) A) and D)
F) None of the above

Question 12

It is possible to capture customers' clicking behavior using clickstream data.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A ________ takes data from the data manufacturers, cleans and processes the data, and locates the data on the shelves.

Accepted Answer

A)   data link layer
B)   data mine
C)   data warehouse
D)   data modelE) B) and D)
F) B) and C)

Question 15

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

Accepted Answer

A)   mart
B)   mine
C)   cube
D)   modelE) A) and B)
F) C) and D)

Question 16

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 the needs of a particular department or functional area of a business.
D)   Data marts are larger than data warehouses.E) None of the above
F) All of the above

Question 17

Data mart is another term used for a data warehouse.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is an example of a measure in an OLAP report?

Accepted Answer

A)   customer type
B)   purchase date
C)   sales region
D)   average costE) None of the above
F) B) and C)

Question 19

A decision tree analysis is a supervised data mining technique.

Accepted Answer

A) True 
 B)False

Question 20

A data mart is a data collection that addresses a particular functional area of the business.

Accepted Answer

A) True 
 B)False

Exam 9: Business Intelligence Systems

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

Correct AnswerverifiedShow Answer

A data mart is larger than a data warehouse.

Correct AnswerverifiedShow Answer

Which of the following observations about RFM and OLAP reports is True?

Correct AnswerverifiedShow Answer

It is possible to capture customers' clicking behavior using clickstream data.

Correct AnswerverifiedShow Answer

OLAP stands for ________.

Correct AnswerverifiedShow Answer

The defining characteristic of OLAP reports is that they are dynamic.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA reporting application is a BI applicat...View AnswerShow Answer

A data mart is a data collection that addresses a particular functional area of the business.

Correct AnswerverifiedShow Answer

A ________ is a hierarchical arrangement of criteria that predict a classification or a value.

Correct AnswerverifiedShow Answer

A decision tree analysis is a supervised data mining technique.

Correct AnswerverifiedShow Answer

Which of the following techniques determine sales patterns?

Correct AnswerverifiedShow Answer

Describe the management functions of business intelligence (BI) server.

Correct AnswerverifiedBusiness intelligence servers provide tw...View AnswerShow Answer

In marketing transactions, the fact that customers who buy product X also buy product Y creates a ________ opportunity. That is, "If they're buying X, sell them Y" or "If they're buying Y, sell them X."

Correct AnswerverifiedShow Answer

It is better to have data with too coarse a granularity than too fine.

Correct AnswerverifiedShow Answer

A ________ takes data from the data manufacturers, cleans and processes the data, and locates the data on the shelves.

Correct AnswerverifiedShow Answer

OLAP provides the ability to sum, count, average, and perform other simple arithmetic operations on groups of data.

Correct AnswerverifiedShow Answer

Data mart is another term used for a data warehouse.

Correct AnswerverifiedShow Answer

Which of the following statements is True about data marts?

Correct AnswerverifiedShow Answer

Which of the following is an example of a measure in an OLAP report?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A reporting application is a BI applicat...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Business intelligence servers provide tw...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified