Question 1

OLAP stands for ________.

Accepted Answer

A) OnLine Analytical Processing 
B) OffLine Analytical Processing 
C) OnLine Analysis Process 
D) OffLine Analysis Process 
E) Old,Lazy And Particular 
A) OnLine Analytical Processing 
B) OffLine Analytical Processing 
C) OnLine Analysis Process 
D) OffLine Analysis Process 
E) Old,Lazy And Particular

Question 2

What is a star schema?

Accepted Answer

The star schema describes the arrangemen

Question 3

Report management systems include the ability to create associated user accounts and groups.

Accepted Answer

A) True 
 B)False

Question 4

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 5

In supervised data mining,statistical techniques are used to estimate the parameters of the model.

Accepted Answer

A) True 
 B)False

Question 6

A report that is sent to users only upon the user's request is called on-demand report.

Accepted Answer

A) True 
 B)False

Question 7

A data mart differs from a data warehouse in that:

Accepted Answer

A) it has a smaller database. 
B) it deals with a particular component or functional area of the business. 
C) data mart users do not have the data management expertise of data warehouse employees. 
D) A and B 
E) A,B and C 
A) it has a smaller database. 
B) it deals with a particular component or functional area of the business. 
C) data mart users do not have the data management expertise of data warehouse employees. 
D) A and B 
E) A,B and C

Question 8

Data mining applications are used to accomplish which of the following tasks?

Accepted Answer

A) Perform what-if analysis 
B) Make predictions 
C) Facilitate decision making 
D) A and B 
E) A,B and C 
A) Perform what-if analysis 
B) Make predictions 
C) Facilitate decision making 
D) A and B 
E) A,B and C

Question 9

Data warehouse data are frequently denormalized.

Accepted Answer

A) True 
 B)False

Question 10

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following popular data mining techniques require special software?

Accepted Answer

A) Decision tree analysis 
B) Logistic regression analysis 
C) Neural networks 
D) A and B 
E) A,B and C 
A) Decision tree analysis 
B) Logistic regression analysis 
C) Neural networks 
D) A and B 
E) A,B and C

Question 12

The metadata maintained by a reporting system database describes ________.

Accepted Answer

A) reports 
B) users 
C) groups 
D) roles 
E) All of the above. 
A) reports 
B) users 
C) groups 
D) roles 
E) All of the above.

Question 13

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

Accepted Answer

A) .025 
B) .075 
C) .100 
D) .125 
E) .200 
A) .025 
B) .075 
C) .100 
D) .125 
E) .200

Question 14

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 15

Which of the following are true about data mining applications?

Accepted Answer

A) They use sophisticated mathematical techniques. 
B) They use sophisticated statistical techniques. 
C) Their report delivery is more important than report delivery for reporting systems. 
D) A and B 
E) A,B and C 
A) They use sophisticated mathematical techniques. 
B) They use sophisticated statistical techniques. 
C) Their report delivery is more important than report delivery for reporting systems. 
D) A and B 
E) A,B and C

Question 16

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

Business Intelligence (BI)systems fall into which of the following categories?

Accepted Answer

A) Processing 
B) Reporting 
C) Data mining 
D) A and B 
E) B and C 
A) Processing 
B) Reporting 
C) Data mining 
D) A and B 
E) B and C

Question 18

In RFM analysis,M stands for "how much money."

Accepted Answer

A) True 
 B)False

Question 19

A Business Intelligence (BI)reporting system:

Accepted Answer

A) creates meaningful information from disparate data sources. 
B) delivers information to users on a timely basis. 
C) uses statistical procedures to predict future events. 
D) A and B 
E) A,B and C 
A) creates meaningful information from disparate data sources. 
B) delivers information to users on a timely basis. 
C) uses statistical procedures to predict future events. 
D) A and B 
E) A,B and C

Question 20

OLAP provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

Accepted Answer

A) True 
 B)False

Exam 15: Database Processing for Business Intelligence Systems

OLAP stands for ________.

What is a star schema?

Report management systems include the ability to create associated user accounts and groups.

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?

In supervised data mining,statistical techniques are used to estimate the parameters of the model.

A report that is sent to users only upon the user's request is called on-demand report.

A data mart differs from a data warehouse in that:

Data mining applications are used to accomplish which of the following tasks?

Data warehouse data are frequently denormalized.

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Which of the following popular data mining techniques require special software?

The metadata maintained by a reporting system database describes ________.

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

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

Which of the following are true about data mining applications?

Which of the following is a common data mining technique?

Business Intelligence (BI)systems fall into which of the following categories?

In RFM analysis,M stands for "how much money."

A Business Intelligence (BI)reporting system:

OLAP provides the ability to sum,count,average and perform other simple arithmetic operations on groups of 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