Question 1

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

Accepted Answer

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

Why is operational data sometimes unusable for Business Intelligence use?

Accepted Answer

Data in operational databases can suffer

Question 3

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

Accepted Answer

A) Cluster analysis 
B) Regression analysis 
C) RFM analysis 
D) Both A and B 
E) All of the above 
A) Cluster analysis 
B) Regression analysis 
C) RFM analysis 
D) Both A and B 
E) All of the above

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which of the following are components of a data warehouse?

Accepted Answer

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

What is data mining application?

Accepted Answer

A data mining application uses sophistic

Question 11

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:

Accepted Answer

A) dirty data. 
B) inconsistent data. 
C) non-integrated data. 
D) a "wrong format" problem. 
E) a "too much data" problem. 
A) dirty data. 
B) inconsistent data. 
C) non-integrated data. 
D) a "wrong format" problem. 
E) a "too much data" problem.

Question 12

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

Accepted Answer

A) .200 
B) .250 
C) .333 
D) .400 
E) .500 
A) .200 
B) .250 
C) .333 
D) .400 
E) .500

Question 13

The reports generated by a reporting system can be classified as:

Accepted Answer

A) static. 
B) dynamic. 
C) fluid. 
D) Both A and B 
E) All of the above 
A) static. 
B) dynamic. 
C) fluid. 
D) Both A and B 
E) All of the above

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What are Business Intelligence (BI)systems?

Accepted Answer

Business Intelligence (BI)systems are in

Question 16

We have done an RFM analysis on our customer data.John Smith has a score of "5 1 1".This means that John:

Accepted Answer

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

What is a star schema?

Accepted Answer

The star schema describes the arrangemen

Question 18

Data mining techniques are used to find patterns and relationships that can be used to:

Accepted Answer

A) report. 
B) classify. 
C) predict. 
D) Both B and C 
E) All of the above 
A) report. 
B) classify. 
C) predict. 
D) Both B and C 
E) All of the above

Question 19

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

Accepted Answer

A) Dirty data 
B) Missing values 
C) Non-integrated data 
D) Both A and B 
E) All of the above 
A) Dirty data 
B) Missing values 
C) Non-integrated data 
D) Both A and B 
E) All of the above

Question 20

A reporting system does not maintain a database of metadata.

Accepted Answer

A) True 
 B)False

Exam 22: Business Intelligence Systems

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

Why is operational data sometimes unusable for Business Intelligence use?

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

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

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

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

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

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

Which of the following are components of a data warehouse?

What is data mining application?

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:

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

The reports generated by a reporting system can be classified as:

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

What are Business Intelligence (BI)systems?

We have done an RFM analysis on our customer data.John Smith has a score of "5 1 1".This means that John:

What is a star schema?

Data mining techniques are used to find patterns and relationships that can be used to:

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

A reporting system does not maintain a database of metadata.

Introduction

Introduction to Structured Query Language SQL

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

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

Filters