Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

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?

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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?

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Market basket analysis is ________.

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

Most data mining techniques are simple and easy to use.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

RFM analysis analyzes and ranks customers based on ________.

Accepted Answer

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

Question 20

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

Exam 24: Business Intelligence Systems

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

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

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

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?

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

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

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

A BI reporting system ________.

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

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

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

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?

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

Market basket analysis is ________.

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

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.

Most data mining techniques are simple and easy to use.

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

RFM analysis analyzes and ranks customers based on ________.

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

Introduction

Introduction to Structured Query Language

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the IDEF1X Standard

E-R Diagrams and the UML Standard

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers, PHP, and the Netbeans IDE

Big Data

Filters

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