Deck 22: Business Intelligence Systems

Question 1

A reporting system does not maintain a database of metadata.

Answer 1

False

Question 2

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

Answer 2

False

Question 3

Business Intelligence (BI)systems are information systems that help users analyze and use data.

Answer 3

True

Question 4

Problematic data include so-called "dirty data."

Question 5

Report delivery is more difficult for data mining than it is for reporting systems.

Question 6

BI reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.

Question 7

Data warehouses are populated with data prepared by Extract,Transform,and Load (ETL)systems.

Question 8

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Question 9

In RFM analysis,R stands for "how recently",F stands for "how frequently" and M stands for "how many months."

Question 10

In a common form of RFM analysis,an RFM score of 5 1 1 means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

Question 11

In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" of "bad".

Question 12

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

Question 13

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

Question 14

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

Question 15

A digital dashboard is an electronic display customized for a individual user.

Question 16

Report modes include dynamic and static.

Question 17

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Question 18

Business Intelligence (BI)systems support operational activities.

Question 19

A data warehouse is a database system that has data for,programs for and personnel specialized in BI processing.

Question 20

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

Question 21

Business Intelligence (BI)systems do which of the following?

A)Analyze current and past activities
B)Predict future events
C)Record and process transactions
D)Both A and B
E)All of the above

Question 22

Market basket analysis is a data mining technique for determining which sets of products customers tend to purchase at the same time.

Question 23

In supervised data mining,statistical techniques are used to estimate the parameters of the model.

Question 24

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

Question 25

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict.

Question 26

In market basket analysis,confidence is the probability that one particular product will be purchased.

Question 27

Report systems include three functions: authoring,management and delivery.

Question 28

Report authoring includes responsibility for delivery of the report.

Question 29

In unsupervised data mining,a model or hypothesis is created ahead of time.

Question 30

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

Question 31

In market basket analysis,support is defined as the probability that two items will be purchased together.

Question 32

Cluster analysis is a commonly used technique in supervised data mining.

Question 33

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

Question 34

Most data mining techniques are simple and easy to use.

Question 35

Reports that do not change once prepared are called static reports.

Question 36

In unsupervised data mining,explanations are created after patterns are found.

Question 37

Report management defines who gets the report,how often,and how it is to be delivered.

Question 38

Report management systems include the ability to create associated user accounts and groups.

Question 39

A report that is sent to users only upon the user's request is called on-demand report.

Question 40

A report that is sent to users on a predetermined schedule is called a push report.

Question 41

Which of the following is a reason that operational data are difficult to read?

A)Dirty data
B)Missing values
C)Non-integrated data
D)Both A and B
E)All of the above

Question 42

One Business Intelligence (BI)reporting system that uses extensions to SQL is:

A)cluster analysis.
B)OLAP.
C)regression analysis.
D)RFM analysis.
E)All of the above

Question 43

The metadata maintained by a reporting system database describes ________.

A)reports
B)users
C)groups
D)roles
E)All of the above.

Question 44

Which of the following are components of a data warehouse?

A)Data extract,transform,and load (ETL)preparation programs
B)Data warehouse data
C)Data warehouse metadata
D)B and C
E)A,B,and C

Question 45

Data mining applications are used accomplish which of the following tasks?

A)Perform what-if analysis
B)Make predications
C)Facilitate decision making
D)Both A and B
E)All of the above

Question 46

The reports generated by a reporting system can be classified as:

A)static.
B)dynamic.
C)fluid.
D)Both A and B
E)All of the above

Question 47

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 ________.

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

Question 48

Which of the following is (are)true about data mining applications?

A)They use sophisticated mathematical techniques.
B)They use sophisticated statistical techniques.
C)Their report delivery is more difficult than report delivery for reporting systems.
D)Both A and B
E)All of the above

Question 49

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337".This is an example of:

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

Question 50

A data mart differs from a data warehouse in that:

A)it has a smaller database.
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)Both A and B
E)All of the above

Question 51

The "R" in RFM analysis stands for:

A)rank.
B)recent.
C)relationship.
D)readiness.
E)random.

Question 52

A data warehouse database differs from an operational database because:

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)Both B and C
E)All of the above

Question 53

Business Intelligence (BI)systems obtain their data by which of the following means?

A)Read and process data from an operational database
B)Process extracts from operational databases
C)Process data purchased from data vendors
D)Both A and B
E)All of the above

Question 54

Business Intelligence (BI)reporting systems can do which of the following operations?

A)Filter data
B)Group data
C)Modify data
D)Both A and B
E)All of the above

Question 55

A BI reporting system:

A)creates meaningful information from disparate data sources.
B)delivers information to users on a timely basis.
C)uses statistical procedures to predict future events.
D)Both A and B
E)All of the above

Question 56

Business Intelligence (BI)systems fall into which of the following categories?

A)Processing
B)Reporting
C)Data mining
D)Both A and B
E)Both B and C

Question 57

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:

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

Question 58

RFM analysis analyzes and ranks customers based on:

A)their purchasing patterns.
B)their income status.
C)their residential location.
D)Both A and B
E)All of the above

Question 59

We have done an RFM analysis on our customer data.John Smith has a score of "5 1 1".This means that John:

A)has ordered recently,and orders a lot when he orders.
B)hasn't ordered recently,but orders a lot when he orders.
C)has ordered recently,but doesn't order a lot when he orders.
D)hasn't ordered recently,and doesn't order a lot when he orders.
E)None of the above is correct.

Question 60

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" score.

A)0 to 5;0
B)0 to 5;5
C)1 to 5,1
D)1 to 5;5
E)1 to 10 ;10

Question 61

Which of the following popular data mining techniques require special software?

A)Decision tree analysis
B)Logistic regression analysis
C)Neural networks
D)A and B
E)A,B,and C

Question 62

Here is Market Basket data for 1,000 transactions at a Drug Store.Use the table below to answer the following questions.

Refer to the table above.What is the lift for Drug B being purchased given that Drug A has been purchased?

A))200
B))250
C))333
D))500
E))667

Question 63

What is a data warehouse?

Question 64

Why is operational data sometimes unusable for Business Intelligence use?

Question 65

Data mining techniques are used to find patterns and relationships that can be used to:

A)report.
B)classify.
C)predict.
D)Both B and C
E)All of the above

Question 66

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

A)Cluster analysis
B)Regression analysis
C)RFM analysis
D)Both A and B
E)All of the above

Question 67

What is a reporting system?

Question 68

Here is Market Basket data for 1,000 transactions at a Drug Store.Use the table below to answer the following questions.

Refer to the table above.What is the support for Drug A and Drug B?

A))025
B))075
C))100
D))125
E))200

Question 69

A report generated by a reporting system is delivered to the appropriate users via a printed report.This system uses which of the following report modes?

A)Push
B)Pull
C)Query
D)OLAP
E)None of the above.

Question 70

OLAP stands for:

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

Question 71

A report generated by a reporting system is delivered to the appropriate users via an electronic display customized for each user.This system uses which of the following media?

A)Paper
B)Web portal
C)Digital dashboard
D)E-mail
E)None of the above

Question 72

Here is Market Basket data for 1,000 transactions at a Drug Store.Use the table below to answer the following questions.

Refer to the table above.What is the definition of confidence for Drug B with reference to Drug A?

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.
E)The probability that Drug B will be purchased given that Drug A has been purchased.

Question 73

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

A)Cluster analysis
B)Regression analysis
C)RFM analysis
D)Both A and B
E)All of the above

Question 74

The reports generated by a reporting system can be delivered in which of the following media?

A)Paper
B)Web portal
C)Digital dashboard
D)E-mail
E)All of the above

Question 75

Here is Market Basket data for 1,000 transactions at a Drug Store.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?

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.
E)The probability that Drug B will be purchased given that Drug A has been purchased.

Question 76

Market basket analysis is:

A)a data mart specific technique.
B)a reporting technique.
C)an RFM application.
D)an OLAP application.
E)a data mining technique.

Question 77

What is a star schema?

Question 78

What are Business Intelligence (BI)systems?

Question 79

Here is Market Basket data for 1,000 transactions at a Drug Store.Use the table below to answer the following questions.

Refer to the table above.What is the confidence of Drug B being purchased given that Drug A has been purchased?

A))200
B))250
C))333
D))400
E))500

Question 80

What is data mining application?