Question 1

A data mart differs from a data warehouse in all the following ways except ________.

Accepted Answer

A) data marts use more operational data 
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) it has a smaller database 
A) data marts use more operational data 
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) it has a smaller database

Question 2

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

Question 3

In market basket analysis,lift is confidence divided by support.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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) efficiency does not matter in a data warehouse 
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) efficiency does not matter in a data warehouse

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Market basket analysis as described in the text uses the technique of conditional probabilities.

Accepted Answer

A) True 
 B)False

Question 8

Why is operational data sometimes unusable for Business Intelligence use?

Accepted Answer

Data in operational databases can suffer

Question 9

What is a reporting system?

Accepted Answer

A reporting system is one of the main ca

Question 10

Report modes include dynamic and static.

Accepted Answer

A) True 
 B)False

Question 11

Business Intelligence (BI)reporting systems can do all of the following operations except ________.

Accepted Answer

A) filter data 
B) group data 
C) modify data 
D) sort data 
A) filter data 
B) group data 
C) modify data 
D) sort data

Question 12

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) non-integrated data 
D) a "wrong format" problem 
A) dirty data 
B) inconsistent data 
C) non-integrated data 
D) a "wrong format" problem

Question 13

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data,and make simple calculations based on the data.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) The probability that Drug A will be purchased. 
B) The probability that Drug B will be purchased. 
C) The probability that both Drug A and Drug B will be purchased. 
D) The probability that Drug A will be purchased given that Drug B has been purchased. 
A) The probability that Drug A will be purchased. 
B) The probability that Drug B will be purchased. 
C) The probability that both Drug A and Drug B will be purchased. 
D) The probability that Drug A will be purchased given that Drug B has been purchased.

Question 15

What is a data warehouse?

Accepted Answer

A data warehouse is a non-operational da

Question 16

The reports generated by a reporting system can be delivered in all of the following media except ________.

Accepted Answer

A) Paper 
B) Smoke signals 
C) Digital dashboard 
D) E-mail 
A) Paper 
B) Smoke signals 
C) Digital dashboard 
D) E-mail

Question 17

The "R" in RFM analysis stands for ________.

Accepted Answer

A) rank 
B) recent 
C) relationship 
D) readiness 
A) rank 
B) recent 
C) relationship 
D) readiness

Question 18

Which of the following is a common unsupervised data mining technique?

Accepted Answer

A) Cluster analysis 
B) Regression analysis 
C) RFM analysis 
D) QBE queries 
A) Cluster analysis 
B) Regression analysis 
C) RFM analysis 
D) QBE queries

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

Exam 24: Business Intelligence Systems

A data mart differs from a data warehouse in all the following ways except ________.

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 market basket analysis,lift is confidence divided by support.

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

A data warehouse database differs from an operational database because ________.

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

Market basket analysis as described in the text uses the technique of conditional probabilities.

Why is operational data sometimes unusable for Business Intelligence use?

What is a reporting system?

Report modes include dynamic and static.

Business Intelligence (BI)reporting systems can do all of the following operations except ________.

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 are used to filter data,sort data,group data,and make simple calculations based on the data.

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

What is a data warehouse?

The reports generated by a reporting system can be delivered in all of the following media except ________.

The "R" in RFM analysis stands for ________.

Which of the following is a common unsupervised data mining technique?

OLAP stands for ________.

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

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