Question 1

Market basket analysis is:

Accepted Answer

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

Question 2

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?

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Problematic data include so-called "dirty data."

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

A)  .200
B)  .250
C)  .333
D)  .500
E)  .667F) B) and D)
G) C) and D)

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.
E)  a "too much data" problem.F) C) and D)
G) B) and C)

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The "R" in RFM analysis stands for:

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A BI reporting system:

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

A data mart differs from a data warehouse in that:

Accepted Answer

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 aboveF) C) and D)
G) A) and E)

Exam 22: Business Intelligence Systems

The "R" in RFM analysis stands for:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Market basket analysis is:

Correct AnswerverifiedShow Answer

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

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

A BI reporting system:

Correct AnswerverifiedShow Answer

A data mart differs from a data warehouse in that:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Problematic data include so-called "dirty data."

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct Answer
verified

Correct Answer
verified