Question 1

Problematic data include so-called "dirty data."

Accepted Answer

A) True 
 B)False

Question 2

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) Both A and B 
E) All of the above 
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) Both A and B 
E) All of the above

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Market basket analysis is:

Accepted Answer

A) a data mart specific technique. 
B) a reporting technique. 
C) an RFM application. 
D) an OLAP application. 
E) a data mining technique. 
A) a data mart specific technique. 
B) a reporting technique. 
C) an RFM application. 
D) an OLAP application. 
E) a data mining technique.

Question 5

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

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

In market basket analysis,support is defined as the probability that two items will be purchased together.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

A 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) Both A and B 
E) All of the above 
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) Both A and B 
E) All of the above

Question 12

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict.

Accepted Answer

A) True 
 B)False

Question 13

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 14

In RFM analysis,R stands for "how recently",F stands for "how frequently" and M stands for "how many months."

Accepted Answer

A) True 
 B)False

Question 15

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 definition of confidence for Drug B with reference to Drug A?

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. 
E) The probability that Drug B will be purchased given that Drug A 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. 
E) The probability that Drug B will be purchased given that Drug A has been purchased.

Question 16

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

Question 17

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 18

The "R" in RFM analysis stands for:

Accepted Answer

A) rank. 
B) recent. 
C) relationship. 
D) readiness. 
E) random. 
A) rank. 
B) recent. 
C) relationship. 
D) readiness. 
E) random.

Question 19

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

Accepted Answer

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

Question 20

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

Exam 22: Business Intelligence Systems

Problematic data include so-called "dirty data."

A data mart differs from a data warehouse in that:

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

Market basket analysis is:

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

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

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

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

In market basket analysis,support is defined as the probability that two items will be purchased together.

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

A BI reporting system:

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict.

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

In RFM analysis,R stands for "how recently",F stands for "how frequently" and M stands for "how many months."

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 definition of confidence for Drug B with reference to Drug A?

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:

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

The "R" in RFM analysis stands for:

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

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?

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