Deck 15: Database Processing for Business Intelligence Systems

Question 1

Business Intelligence (BI)systems obtain data in three different ways.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

Data warehouses also store the data warehouse metadata.

Question 6

Metadata about the data's source,format,assumptions and constraints are kept in a data warehouse metadata database.

Question 7

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

Question 8

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

Question 9

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 10

Data warehouse data are frequently denormalized.

Question 11

Business Intelligence (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 12

Data warehouses often include data purchased from outside vendors.

Question 13

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

Question 14

In a common form of RFM analysis,customers are sorted in five groups and given an associated score depending on their group.

Question 15

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

Question 16

A data warehouse is a database system that has data,programs and personnel specialized in Business Intelligence (BI)processing.

Question 17

Problematic data are called "dirty data."

Question 18

Data warehouses are populated with data prepared by data extraction,transformation and load (ETL)programs.

Question 19

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

Question 20

Business Intelligence (BI)systems support operational activities.

Question 21

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

Question 22

An OLAP cube is limited to three axes.

Question 23

Report authoring includes responsibility for delivery of the report.

Question 24

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

Question 25

In RFM analysis,M stands for "how much money."

Question 26

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

Question 27

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 28

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

Question 29

The term drill down refers to the capability of seeing the data in smaller and smaller units.

Question 30

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

Question 31

In RFM analysis,F stands for "how frequently."

Question 32

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 33

Report modes include dynamic and static.

Question 34

In RFM analysis,R stands for "how recently."

Question 35

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

Question 36

A reporting system does not maintain a database of metadata.

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

As specified in the text,three popular data mining techniques are cluster analysis,logistic regression analysis,and neural networks.

Question 42

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)A and B
E)A,B and C

Question 43

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

Question 44

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

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

Question 45

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

Question 46

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

A)cluster analysis.
B)OLAP.
C)regression analysis.
D)RFM analysis.
E)A,B and C

Question 47

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

A)Perform what-if analysis
B)Make predictions
C)Facilitate decision making
D)A and B
E)A,B and C

Question 48

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

Question 49

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

Question 50

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)A and B
E)A,B,and C

Question 51

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

Question 52

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

A)Dirty data
B)Missing values
C)Nonintegrated data
D)A and B
E)A,B and C

Question 53

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

Question 54

Most data mining techniques are simple and easy to use.

Question 55

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

Question 56

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

Question 57

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)nonintegrated data
D)a "wrong format" problem
E)a "too much data" problem

Question 58

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

A)Filter data
B)Group data
C)Modify data
D)A and B
E)A,B and C

Question 59

Which of the following are true about data mining applications?

A)They use sophisticated mathematical techniques.
B)They use sophisticated statistical techniques.
C)Their report delivery is more important than report delivery for reporting systems.
D)A and B
E)A,B and C

Question 60

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

Question 61

The reports generated by a reporting system can be classified as ________.

A)static
B)dynamic
C)fluid
D)A and B
E)A,B and C

Question 62

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" (from the vendors point of view)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 63

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 64

The "R" in RFM analysis stands for ________.

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

Question 65

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 66

A Business Intelligence (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)A and B
E)A,B and C

Question 67

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)A and B
E)A,B and C

Question 68

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)nonintegrated data
D)a "wrong format" problem
E)a "too much data" problem

Question 69

The "M" in RFM analysis stands for ________.

A)money
B)mostly
C)modest
D)modern
E)modem

Question 70

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 71

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 denormalized.
D)B and C
E)A,B and C

Question 72

In OLAP,the characteristic of a measure is called a ________.

A)level
B)dimension
C)measure
D)member
E)slice

Question 73

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 74

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 75

RFM analysis analyzes and ranks customers based on:

A)their purchasing patterns.
B)their income status.
C)their residential location.
D)A and B
E)A,B and C

Question 76

In OLAP,the data item of interest is called a ________.

A)level
B)dimension
C)measure
D)member
E)slice

Question 77

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 78

An OLAP cube is called that because some products show OLAP displays on ________ axes.

A)one
B)two
C)three
D)four
E)a number that varies depending upon the analysis being done

Question 79

OLAP stands for ________.

A)OnLine Analytical Processing
B)OffLine Analytical Processing
C)OnLine Analysis Process
D)OffLine Analysis Process
E)Old,Lazy And Particular

Question 80

The metadata maintained by a reporting system database describes ________.

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