Deck 24: Business Intelligence Systems

Question 1

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.

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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 6

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

Question 7

Business Intelligence (BI)systems support operational activities.

Question 8

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

Question 9

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

Question 10

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

Question 11

Problematic data include so-called dirty data.

Question 12

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 13

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

Question 14

Report modes include dynamic and static.

Question 15

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

Question 16

A reporting system does not maintain a database of metadata.

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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 are correct

Question 24

Report authoring includes responsibility for delivery of the report.

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

Most data mining techniques are simple and easy to use.

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

A)Dirty data
B)Large values
C)Non-integrated data
D)Missing values

Question 42

Business Intelligence (BI)systems obtain their data by all of the following means except ________.

A)read and process data from an operational database
B)triggers defined on the operational database
C)process data purchased from data vendors
D)process extracts from operational databases

Question 43

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

Question 44

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

Question 45

The "R" in RFM analysis stands for ________.

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

Question 46

Data mining applications are used accomplish all of the following tasks except ________.

A)update the database
B)make predications
C)facilitate decision making
D)perform what-if analysis

Question 47

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

A)Processing
B)Reporting
C)Data mining
D)Both B and C are correct

Question 48

To produce the set of customers with a R score of 2,the SQL SELECT TOP ________ PERCENT syntax should be used.

A)50
B)33
C)25
D)20

Question 49

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

Question 50

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 are correct

Question 51

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

Question 52

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

A)cluster analysis
B)OLAP
C)regression analysis
D)RFM analysis

Question 53

RFM analysis analyzes and ranks customers based on ________.

A)their purchasing patterns
B)their income status
C)their residential location.
D)their age

Question 54

Which of the following is not a component of a data warehouse?

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

Question 55

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 are correct

Question 56

RFM analysis can be done using SQL ________.

A)user-defined functions
B)stored procedures
C)triggers
D)union queries

Question 57

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

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

Question 58

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)efficiency does not matter in a data warehouse

Question 59

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

Question 60

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

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 61

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 62

The reports generated by a reporting system can be classified as any of the following except ________.

A)static
B)dynamic
C)fluid
D)push

Question 63

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 are correct

Question 64

What is data mining application?

Question 65

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 confidence of Drug B being purchased given that Drug A has been purchased?

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

Question 66

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

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

Question 67

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 support for Drug A and Drug B?

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

Question 68

Market basket analysis is ________.

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

Question 69

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

Question 70

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

A)Cluster analysis
B)Regression analysis
C)RFM analysis
D)SQL analysis

Question 71

What are Business Intelligence (BI)systems?

Question 72

What is a reporting system?

Question 73

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 lift for Drug B being purchased given that Drug A has been purchased?

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

Question 74

The metadata maintained by a reporting system database describes all of the following except ________.

A)triggers
B)users
C)groups
D)reports

Question 75

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

Question 76

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

A)Push
B)Pull
C)Query
D)OLAP

Question 77

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

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

Question 78

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?

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 79

Why is operational data sometimes unusable for Business Intelligence use?

Question 80

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

A)Decision tree analysis
B)Logistic regression analysis
C)Market basket analysis
D)Neural networks