Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is a common supervised 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 6

One Business Intelligence (BI)reporting system that uses extensions to SQL is:

Accepted Answer

A) cluster analysis. 
B) OLAP. 
C) regression analysis. 
D) RFM analysis. 
E) All of the above 
A) cluster analysis. 
B) OLAP. 
C) regression analysis. 
D) RFM analysis. 
E) All of the above

Question 7

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

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

A) True 
 B)False

Question 10

What is a data warehouse?

Accepted Answer

A data warehouse is a non-operational da

Question 11

What is a reporting system?

Accepted Answer

A reporting system is one of the main ca

Question 12

Report modes include dynamic and static.

Accepted Answer

A) True 
 B)False

Question 13

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?

Accepted Answer

A) Paper 
B) Web portal 
C) Digital dashboard 
D) E-mail 
E) None of the above 
A) Paper 
B) Web portal 
C) Digital dashboard 
D) E-mail 
E) None of the above

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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.

Accepted Answer

A) True 
 B)False

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) Both A and B 
E) All of the above 
A) their purchasing patterns. 
B) their income status. 
C) their residential location. 
D) Both A and B 
E) All of the above

Question 17

Data mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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.

Accepted Answer

A) True 
 B)False

Exam 22: Business Intelligence Systems

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

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

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

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

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

One Business Intelligence (BI)reporting system that uses extensions to SQL is:

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

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?

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

What is a data warehouse?

What is a reporting system?

Report modes include dynamic and static.

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 data warehouse is a database system that has data for,programs for and personnel specialized in BI processing.

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.

RFM analysis analyzes and ranks customers based on:

Data mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

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

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

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.

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