Question 1

Market basket analysis is ________.

Accepted Answer

A) a reporting technique 
B) an OLAP application 
C) a data mining technique 
D) A and B 
E) A,B and C 
A) a reporting technique 
B) an OLAP application 
C) a data mining technique 
D) A and B 
E) A,B and C

Question 2

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

Accepted Answer

A) Dirty data 
B) Missing values 
C) Nonintegrated data 
D) A and B 
E) A,B and C 
A) Dirty data 
B) Missing values 
C) Nonintegrated data 
D) A and B 
E) A,B and C

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

As specified in the text,three popular data mining techniques are cluster analysis,logistic regression analysis,and neural networks.

Accepted Answer

A) True 
 B)False

Question 5

Data warehouses often include data purchased from outside vendors.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Data warehouses are populated with data prepared by data extraction,transformation and load (ETL)programs.

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

Accepted Answer

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

Question 9

What is an Excel PivotTable?

Accepted Answer

A PivotTable is the reporting mechanism

Question 10

What is a reporting system?

Accepted Answer

A reporting system is one of the main ca

Question 11

Business Intelligence (BI)systems obtain data in three different ways.

Accepted Answer

A) True 
 B)False

Question 12

What is a conformed dimension?

Accepted Answer

A conformed dimension is a dimension tab

Question 13

What are Business Intelligence (BI)systems?

Accepted Answer

Business Intelligence (BI)systems are in

Question 14

We have obtained access to the company's operational data.We have been asked to produce a report with an item by item analysis of sales,but the only sales figure available is the total sale value for each order.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

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.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 18

Business Intelligence (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 19

The reports generated by a reporting system can be delivered in which of the following media?

Accepted Answer

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

Question 20

A reporting system does not maintain a database of metadata.

Accepted Answer

A) True 
 B)False

Exam 15: Database Processing for Business Intelligence Systems

Market basket analysis is ________.

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

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

As specified in the text,three popular data mining techniques are cluster analysis,logistic regression analysis,and neural networks.

Data warehouses often include data purchased from outside vendors.

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.

Data warehouses are populated with data prepared by data extraction,transformation and load (ETL)programs.

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

What is an Excel PivotTable?

What is a reporting system?

Business Intelligence (BI)systems obtain data in three different ways.

What is a conformed dimension?

What are Business Intelligence (BI)systems?

We have obtained access to the company's operational data.We have been asked to produce a report with an item by item analysis of sales,but the only sales figure available is the total sale value for each order.This is an example of ________.

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

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

We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.This is an example of ________.

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

The reports generated by a reporting system can be delivered in which of the following media?

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

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