Question 1

What is a reporting system?

Accepted Answer

A reporting system is one of the main ca...

Question 2

A data mart differs from a data warehouse in all the following ways except ________.

Accepted Answer

A)  data marts use more operational data
B)  it deals with a particular component or functional area of the business
C)  data mart users do not have the data management expertise of data warehouse employees
D)  it has a smaller database

Question 3

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data,and make simple calculations based on the data.

Accepted Answer

A) True 
 B)False

Question 4

The "R" in RFM analysis stands for ________.

Accepted Answer

A)  rank
B)  recent
C)  relationship
D)  readiness

Question 5

The reports generated by a reporting system can be delivered in all of the following media except ________.

Accepted Answer

A)  Paper
B)  Smoke signals
C)  Digital dashboard
D)  E-mail

Question 6

Why is operational data sometimes unusable for Business Intelligence use?

Accepted Answer

Data in operational databases can suffer...

Question 7

Data mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Accepted Answer

A) True 
 B)False

Question 8

Here is Market Basket data for 1,000 transactions at a Drug Store.All transactions involve 1 or 2 drugs.Use the table below to answer the following questions.
 
-Refer to the table above.What is the definition of support for Drug A and Drug B?

Accepted Answer

A)  The probability that Drug A will be purchased.
B)  The probability that Drug B will be purchased.
C)  The probability that both Drug A and Drug B will be purchased.
D)  The probability that Drug A will be purchased given that Drug B has been purchased.

Question 9

OLAP stands for ________.

Accepted Answer

A)  Online Analytical Processing
B)  Offline Analytical Processing
C)  Online Analysis Process
D)  Offline Analytical Process
E)  Lazy,Old And Particular

Question 10

We have obtained access to the company's operational data.We have been asked to produce a report with an item by item analysis of sales,but the only sales figure available is the total sale value for each order.This is an example of ________.

Accepted Answer

A)  dirty data
B)  inconsistent data
C)  nonintegrated data
D)  a "wrong format" problem

Question 11

Market basket analysis as described in the text uses the technique of conditional probabilities.

Accepted Answer

A) True 
 B)False

Question 12

RFM analysis is a way of analyzing and ranking customers based on on-line survey data.

Accepted Answer

A) True 
 B)False

Question 13

We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.This is an example of ________.

Accepted Answer

A)  dirty data
B)  inconsistent data
C)  non-integrated data
D)  a "wrong format" problem

Question 14

Reports that rely on the most current data when they are prepared are called dynamic reports.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is a common unsupervised data mining technique?

Accepted Answer

A)  Cluster analysis
B)  Regression analysis
C)  RFM analysis
D)  QBE queries

Question 16

Business Intelligence (BI) reporting systems can do all of the following operations except ________.

Accepted Answer

A)  filter data
B)  group data
C)  modify data
D)  sort data

Question 17

Report modes include dynamic and static.

Accepted Answer

A) True 
 B)False

Question 18

A data warehouse database differs from an operational database because ________.

Accepted Answer

A)  data warehouse data are not stored in tables
B)  data warehouse databases do not have metadata
C)  data warehouse data are often stored in a dimensional database
D)  efficiency does not matter in a data warehouse

Question 19

In market basket analysis,lift is confidence divided by support.

Accepted Answer

A) True 
 B)False

Question 20

What is a data warehouse?

Accepted Answer

A data warehouse is a non-operational da...

Exam 24: Business Intelligence Systems

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data,and make simple calculations based on the data.

Correct AnswerverifiedShow Answer

Here is Market Basket data for 1,000 transactions at a Drug Store.All transactions involve 1 or 2 drugs.Use the table below to answer the following questions. -Refer to the table above.What is the definition of support for Drug A and Drug B?

Correct AnswerverifiedShow Answer

Market basket analysis as described in the text uses the technique of conditional probabilities.

Correct AnswerverifiedShow Answer

RFM analysis is a way of analyzing and ranking customers based on on-line survey data.

Correct AnswerverifiedShow Answer

The "R" in RFM analysis stands for ________.

Correct AnswerverifiedShow Answer

Why is operational data sometimes unusable for Business Intelligence use?

Correct AnswerverifiedData in operational databases can suffer...View AnswerShow Answer

In market basket analysis,lift is confidence divided by support.

Correct AnswerverifiedShow Answer

What is a reporting system?

Correct AnswerverifiedA reporting system is one of the main ca...View AnswerShow Answer

OLAP stands for ________.

Correct AnswerverifiedShow Answer

Report modes include dynamic and static.

Correct AnswerverifiedShow Answer

What is a data warehouse?

Correct AnswerverifiedA data warehouse is a non-operational da...View AnswerShow Answer

A data warehouse database differs from an operational database because ________.

Correct AnswerverifiedShow Answer

Reports that rely on the most current data when they are prepared are called dynamic reports.

Correct AnswerverifiedShow Answer

The reports generated by a reporting system can be delivered in all of the following media except ________.

Correct AnswerverifiedShow Answer

A data mart differs from a data warehouse in all the following ways except ________.

Correct AnswerverifiedShow Answer

We have obtained access to the company's operational data.We have been asked to produce a report with an item by item analysis of sales,but the only sales figure available is the total sale value for each order.This is an example of ________.

Correct AnswerverifiedShow Answer

We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.This is an example of ________.

Correct AnswerverifiedShow Answer

Which of the following is a common unsupervised data mining technique?

Correct AnswerverifiedShow Answer

Data mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Correct AnswerverifiedShow Answer

Business Intelligence (BI) reporting systems can do all of the following operations except ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data in operational databases can suffer...
View Answer

Correct Answer
verified

Correct Answer
verified
A reporting system is one of the main ca...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data warehouse is a non-operational da...
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

Correct Answer
verified