Deck 17: Getting Started With Web Servers, php, and the Netbeans IDE

Question 1

Report modes include dynamic and static.

Answer 1

False

Question 2

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.

Answer 2

True

Question 3

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

Answer 3

False

Question 4

Problematic data include so-called "dirty data."

Question 5

Business Intelligence (BI)systems support operational activities.

Question 6

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

Question 7

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

Question 8

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 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

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

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

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

Question 17

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 18

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 19

A reporting system does not maintain a database of metadata.

Question 20

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

Question 21

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

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

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

Question 24

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

Question 25

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

Question 26

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

Question 27

Most data mining techniques are simple and easy to use.

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

Report authoring includes responsibility for delivery of the report.

Question 35

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

Question 36

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 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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 42

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

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 45

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 46

Data mining applications are used to 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 47

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 difficult than report delivery for reporting systems.
D) Both A and B
E) All of the above

Question 48

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 49

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 50

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 51

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 52

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 53

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 54

The "R" in RFM analysis stands for:

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

Question 55

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 56

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

Question 58

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

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 61

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 62

Here is Market Basket data for 1,000 transactions at a Drug Store. Use the table below to answer the following questions.
$$\begin{array} { | l | c | c | c | } \hline { \begin{array} { c } \text { 1,000 } \\\text { Transactions }\end{array} } & \begin{array} { c } \text { Drug A } \\500\end{array} & \begin{array} { c } \text { Drug B } \\300\end{array} & \begin{array} { c } \text { Drug C } \\200\end{array} \\\hline \text { Drug A } & 75 & 100 & 125 \\\hline \text { Drug B } & 100 & 25 & 75 \\\hline \text { Drug C } & 125 & 75 & 0 \\\hline \text { No Additional Drug } & 200 & 100 & 0 \\\hline\end{array}$$

-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 63

Here is Market Basket data for 1,000 transactions at a Drug Store. Use the table below to answer the following questions.
$$\begin{array} { | l | c | c | c | } \hline { \begin{array} { c } \text { 1,000 } \\\text { Transactions }\end{array} } & \begin{array} { c } \text { Drug A } \\500\end{array} & \begin{array} { c } \text { Drug B } \\300\end{array} & \begin{array} { c } \text { Drug C } \\200\end{array} \\\hline \text { Drug A } & 75 & 100 & 125 \\\hline \text { Drug B } & 100 & 25 & 75 \\\hline \text { Drug C } & 125 & 75 & 0 \\\hline \text { No Additional Drug } & 200 & 100 & 0 \\\hline\end{array}$$

-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 64

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 65

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 66

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 67

Business Intelligence (BI)systems fall into two broad categories: ________ and ________.

Question 68

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 69

Here is Market Basket data for 1,000 transactions at a Drug Store. Use the table below to answer the following questions.
$$\begin{array} { | l | c | c | c | } \hline { \begin{array} { c } \text { 1,000 } \\\text { Transactions }\end{array} } & \begin{array} { c } \text { Drug A } \\500\end{array} & \begin{array} { c } \text { Drug B } \\300\end{array} & \begin{array} { c } \text { Drug C } \\200\end{array} \\\hline \text { Drug A } & 75 & 100 & 125 \\\hline \text { Drug B } & 100 & 25 & 75 \\\hline \text { Drug C } & 125 & 75 & 0 \\\hline \text { No Additional Drug } & 200 & 100 & 0 \\\hline\end{array}$$

-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 70

Here is Market Basket data for 1,000 transactions at a Drug Store. Use the table below to answer the following questions.
$$\begin{array} { | l | c | c | c | } \hline { \begin{array} { c } \text { 1,000 } \\\text { Transactions }\end{array} } & \begin{array} { c } \text { Drug A } \\500\end{array} & \begin{array} { c } \text { Drug B } \\300\end{array} & \begin{array} { c } \text { Drug C } \\200\end{array} \\\hline \text { Drug A } & 75 & 100 & 125 \\\hline \text { Drug B } & 100 & 25 & 75 \\\hline \text { Drug C } & 125 & 75 & 0 \\\hline \text { No Additional Drug } & 200 & 100 & 0 \\\hline\end{array}$$

-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 71

Business Intelligence (BI)________ uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Question 72

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 73

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 74

A(n)________ is an information system that helps users analyze and use data.

Question 75

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

Question 76

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 77

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 78

Problematic data are called ________.

Question 79

Here is Market Basket data for 1,000 transactions at a Drug Store. Use the table below to answer the following questions.
$$\begin{array} { | l | c | c | c | } \hline { \begin{array} { c } \text { 1,000 } \\\text { Transactions }\end{array} } & \begin{array} { c } \text { Drug A } \\500\end{array} & \begin{array} { c } \text { Drug B } \\300\end{array} & \begin{array} { c } \text { Drug C } \\200\end{array} \\\hline \text { Drug A } & 75 & 100 & 125 \\\hline \text { Drug B } & 100 & 25 & 75 \\\hline \text { Drug C } & 125 & 75 & 0 \\\hline \text { No Additional Drug } & 200 & 100 & 0 \\\hline\end{array}$$

-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 80

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