Question 1

A digital dashboard is an electronic display customized for a individual user.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Question 3

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  True

Question 4

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.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is (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 difficult than report delivery for reporting systems. 
D) Both A and B 
E) All of the above 
A) They use sophisticated mathematical techniques. 
B) They use sophisticated statistical techniques. 
C) Their report delivery is more difficult than report delivery for reporting systems. 
D) Both A and B 
E) All of the above

Question 7

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

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

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 10

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

Accepted Answer

A) Perform what-if analysis 
B) Make predications 
C) Facilitate decision making 
D) Both A and B 
E) All of the above 
A) Perform what-if analysis 
B) Make predications 
C) Facilitate decision making 
D) Both A and B 
E) All of the above

Question 11

OLAP stands for:

Accepted Answer

A) Online Analytical Processing. 
B) Offline Analytical Processing. 
C) Online Analysis Process. 
D) Offline Analytical Process. 
E) Lazy,Old And Particular. 
A) Online Analytical Processing. 
B) Offline Analytical Processing. 
C) Online Analysis Process. 
D) Offline Analytical Process. 
E) Lazy,Old And Particular.

Question 12

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 13

A data warehouse database differs from an operational database because:

Accepted Answer

A) data warehouse data are not stored in tables. 
B) data warehouse databases do not have metadata. 
C) data warehouse data are often stored in a dimensional database. 
D) Both B and C 
E) All of the above 
A) data warehouse data are not stored in tables. 
B) data warehouse databases do not have metadata. 
C) data warehouse data are often stored in a dimensional database. 
D) Both B and C 
E) All of the above

Question 14

BI reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.

Accepted Answer

A) True 
 B)False

Question 15

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) Both A and B 
E) All of the above 
A) Read and process data from an operational database 
B) Process extracts from operational databases 
C) Process data purchased from data vendors 
D) Both A and B 
E) All of the above

Question 16

Report authoring includes responsibility for delivery of the report.

Accepted Answer

A) True 
 B)False

Question 17

Business Intelligence (BI)systems support operational activities.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) Filter data 
B) Group data 
C) Modify data 
D) Both A and B 
E) All of the above 
A) Filter data 
B) Group data 
C) Modify data 
D) Both A and B 
E) All of the above

Question 19

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" 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 20

Most data mining techniques are simple and easy to use.

Accepted Answer

A) True 
 B)False

Exam 22: Business Intelligence Systems

A digital dashboard is an electronic display customized for a individual user.

The metadata maintained by a reporting system database describes ________.

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

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 systems include the ability to create associated user accounts and groups.

Which of the following is (are)true about data mining applications?

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

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?

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

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

OLAP stands for:

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

A data warehouse database differs from an operational database because:

BI reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.

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

Report authoring includes responsibility for delivery of the report.

Business Intelligence (BI)systems support operational activities.

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

RFM scores commonly range from ________,with ________ being the "high" or "most desirable" score.

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

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

RFM scores commonly range from ,with being the "high" or "most desirable" score.