Question 1

The term drill down refers to the capability of seeing the data in smaller and smaller units.

Accepted Answer

A) True 
 B)False  True

Question 2

A report generated by a reporting system is delivered to the appropriate users via a printed report.This system uses which of the following report modes?

Accepted Answer

A) Push 
B) Pull 
C) Query 
D) OLAP 
E) None of the above. 
A) Push 
B) Pull 
C) Query 
D) OLAP 
E) None of the above. A

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

In RFM analysis,R stands for "how recently."

Accepted Answer

A) True 
 B)False

Question 5

RFM analysis is a way of analyzing and ranking customers based on online survey data.

Accepted Answer

A) True 
 B)False

Question 6

What is a data mining application?

Accepted Answer

A data mining application uses sophistic

Question 7

What is a slowly changing dimension?

Accepted Answer

A slowly changing dimension is an attrib

Question 8

The "M" in RFM analysis stands for ________.

Accepted Answer

A) money 
B) mostly 
C) modest 
D) modern 
E) modem 
A) money 
B) mostly 
C) modest 
D) modern 
E) modem

Question 9

Which of the following is a supervised data mining technique?

Accepted Answer

A) Cluster analysis 
B) Regression analysis 
C) RFM analysis 
D) A and B 
E) A,B and C 
A) Cluster analysis 
B) Regression analysis 
C) RFM analysis 
D) A and B 
E) A,B and C

Question 10

Why is operational data sometimes unusable for Business Intelligence (BI)use?

Accepted Answer

Data in operational databases can suffer

Question 11

The reports generated by a reporting system can be classified as ________.

Accepted Answer

A) static 
B) dynamic 
C) fluid 
D) A and B 
E) A,B and C 
A) static 
B) dynamic 
C) fluid 
D) A and B 
E) A,B and C

Question 12

Business Intelligence (BI)systems obtain their data by which of the following means?

Accepted Answer

A) Read and process data from an operational database 
B) Process extracts from operational databases 
C) Process data purchased from data vendors 
D) A and B 
E) A,B and C 
A) Read and process data from an operational database 
B) Process extracts from operational databases 
C) Process data purchased from data vendors 
D) A and B 
E) A,B and C

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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) nonintegrated data 
D) a "wrong format" problem 
E) a "too much data" problem 
A) dirty data 
B) inconsistent data 
C) nonintegrated data 
D) a "wrong format" problem 
E) a "too much data" problem

Question 15

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" (from the vendors point of view)score.

Accepted Answer

A) 0 to 5;0 
B) 0 to 5;5 
C) 1 to 5;1 
D) 1 to 5;5 
E) 1 to 10;10 
A) 0 to 5;0 
B) 0 to 5;5 
C) 1 to 5;1 
D) 1 to 5;5 
E) 1 to 10;10

Question 16

In RFM analysis,F stands for "how frequently."

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) report 
B) classify 
C) predict 
D) B and C 
E) A,B and C 
A) report 
B) classify 
C) predict 
D) B and C 
E) A,B and C

Question 18

What is a data warehouse?

Accepted Answer

A data warehouse is a nonoperational dat

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Problematic data are called "dirty data."

Accepted Answer

A) True 
 B)False

Exam 15: Database Processing for Business Intelligence Systems

The term drill down refers to the capability of seeing the data in smaller and smaller units.

A report generated by a reporting system is delivered to the appropriate users via a printed report.This system uses which of the following report modes?

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

In RFM analysis,R stands for "how recently."

RFM analysis is a way of analyzing and ranking customers based on online survey data.

What is a data mining application?

What is a slowly changing dimension?

The "M" in RFM analysis stands for ________.

Which of the following is a supervised data mining technique?

Why is operational data sometimes unusable for Business Intelligence (BI)use?

The reports generated by a reporting system can be classified as ________.

Business Intelligence (BI)systems obtain their data by which of the following means?

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

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

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" (from the vendors point of view)score.

In RFM analysis,F stands for "how frequently."

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

What is a data warehouse?

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

Problematic data are called "dirty data."

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

RFM scores commonly range from ,with being the "high" or "most desirable" (from the vendors point of view)score.