Question 1

Report delivery is more difficult for data mining than it is for reporting systems.

Accepted Answer

A) True 
 B)False

Question 2

Here is Market Basket data for 1,000 transactions at a Drug Store.All transactions involve 1 or 2 drugs.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 
A) .200 
B) .250 
C) .333 
D) .400

Question 3

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 4

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 5

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 6

Data warehouses are populated with data prepared by Extract,Transform,and Load (ETL)systems.

Accepted Answer

A) True 
 B)False

Question 7

What is data mining application?

Accepted Answer

A data mining application uses sophistic

Question 8

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 9

What is a star schema?

Accepted Answer

The star schema describes the arrangemen

Question 10

We have done an RFM analysis on our customer data.John Smith has a score of "5 1 1".This means that John ________.

Accepted Answer

A) has ordered recently,and orders a lot when he orders 
B) hasn't ordered recently,but orders a lot when he orders 
C) has ordered recently,but doesn't order a lot when he orders 
D) hasn't ordered recently,and doesn't order a lot when he orders 
A) has ordered recently,and orders a lot when he orders 
B) hasn't ordered recently,but orders a lot when he orders 
C) has ordered recently,but doesn't order a lot when he orders 
D) hasn't ordered recently,and doesn't order a lot when he orders

Question 11

Business Intelligence (BI)systems obtain their data by all of the following means except ________.

Accepted Answer

A) read and process data from an operational database 
B) triggers defined on the operational database 
C) process data purchased from data vendors 
D) process extracts from operational databases 
A) read and process data from an operational database 
B) triggers defined on the operational database 
C) process data purchased from data vendors 
D) process extracts from operational databases

Question 12

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 
A) cluster analysis 
B) OLAP 
C) regression analysis 
D) RFM analysis

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A report that is sent to users on a predetermined schedule is called a push report.

Accepted Answer

A) True 
 B)False

Question 15

Business Intelligence (BI)systems are information systems that help users analyze and use data.

Accepted Answer

A) True 
 B)False

Question 16

Business Intelligence (BI)systems support operational activities.

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) Both B and C are correct 
A) report 
B) classify 
C) predict 
D) Both B and C are correct

Question 18

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

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

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 
A) Paper 
B) Web portal 
C) Digital dashboard 
D) E-mail

Exam 24: Business Intelligence Systems

Report delivery is more difficult for data mining than it is for reporting systems.

Here is Market Basket data for 1,000 transactions at a Drug Store.All transactions involve 1 or 2 drugs.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?

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

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

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

Data warehouses are populated with data prepared by Extract,Transform,and Load (ETL)systems.

What is data mining application?

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

What is a star schema?

We have done an RFM analysis on our customer data.John Smith has a score of "5 1 1".This means that John ________.

Business Intelligence (BI)systems obtain their data by all of the following means except ________.

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

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

A report that is sent to users on a predetermined schedule is called a push report.

Business Intelligence (BI)systems are information systems that help users analyze and use data.

Business Intelligence (BI)systems support operational activities.

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

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

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

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?

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Big Data

Filters