Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 support for Drug A and Drug B?

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

An OLAP cube is limited to three axes.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

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

Compare the characteristics of an operational database and a dimensional database.

Accepted Answer

An operational database is used for stru

Question 13

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 14

Business Intelligence (BI)systems support operational activities.

Accepted Answer

A) True 
 B)False

Question 15

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 16

RFM analysis analyzes and ranks customers based on:

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Most data mining techniques are simple and easy to use.

Accepted Answer

A) True 
 B)False

Exam 15: Database Processing for Business Intelligence Systems

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

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

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

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

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

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

Which of the following are components of a data warehouse?

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 support for Drug A and Drug B?

An OLAP cube is limited to three axes.

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

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

Compare the characteristics of an operational database and a dimensional database.

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

Business Intelligence (BI)systems support operational activities.

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

RFM analysis analyzes and ranks customers based on:

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

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

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

Most data mining techniques are simple and easy to use.

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

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters