Question 1

Data warehouses are populated with data prepared by ________ programs.

Accepted Answer

Extract,Tr

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

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

Question 4

Market basket analysis,as described in the text,uses the statistical technique of ________.

Accepted Answer

conditiona

Question 5

Report authoring includes responsibility for delivery of the report.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Here is Market Basket data for 1,000 transactions at a Drug Store. Use the table below to answer the following questions.
$$\begin{array} { | l | c | c | c | } 
\hline { \begin{array} { c } 
\text { 1,000 } \
\text { Transactions }
\end{array} } & \begin{array} { c } 
\text { Drug A } \
500
\end{array} & \begin{array} { c } 
\text { Drug B } \
300
\end{array} & \begin{array} { c } 
\text { Drug C } \
200
\end{array} \
\hline \text { Drug A } & 75 & 100 & 125 \
\hline \text { Drug B } & 100 & 25 & 75 \
\hline \text { Drug C } & 125 & 75 & 0 \
\hline \text { No Additional Drug } & 200 & 100 & 0 \
\hline
\end{array}$$
-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 8

Report systems include three functions: authoring,management and delivery.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." 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 12

Problematic data include so-called "dirty data."

Accepted Answer

A) True 
 B)False

Question 13

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

In unsupervised data mining,a model or hypothesis is created ahead of time.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Here is Market Basket data for 1,000 transactions at a Drug Store. Use the table below to answer the following questions.
$$\begin{array} { | l | c | c | c | } 
\hline { \begin{array} { c } 
\text { 1,000 } \
\text { Transactions }
\end{array} } & \begin{array} { c } 
\text { Drug A } \
500
\end{array} & \begin{array} { c } 
\text { Drug B } \
300
\end{array} & \begin{array} { c } 
\text { Drug C } \
200
\end{array} \
\hline \text { Drug A } & 75 & 100 & 125 \
\hline \text { Drug B } & 100 & 25 & 75 \
\hline \text { Drug C } & 125 & 75 & 0 \
\hline \text { No Additional Drug } & 200 & 100 & 0 \
\hline
\end{array}$$
-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 18

Here is Market Basket data for 1,000 transactions at a Drug Store. Use the table below to answer the following questions.
$$\begin{array} { | l | c | c | c | } 
\hline { \begin{array} { c } 
\text { 1,000 } \
\text { Transactions }
\end{array} } & \begin{array} { c } 
\text { Drug A } \
500
\end{array} & \begin{array} { c } 
\text { Drug B } \
300
\end{array} & \begin{array} { c } 
\text { Drug C } \
200
\end{array} \
\hline \text { Drug A } & 75 & 100 & 125 \
\hline \text { Drug B } & 100 & 25 & 75 \
\hline \text { Drug C } & 125 & 75 & 0 \
\hline \text { No Additional Drug } & 200 & 100 & 0 \
\hline
\end{array}$$
-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

Data warehouses are populated with data prepared by ________ programs.

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.

Market basket analysis,as described in the text,uses the statistical technique of ________.

Report authoring includes responsibility for delivery of the report.

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

Report systems include three functions: authoring,management and delivery.

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

A BI reporting system:

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of:

Problematic data include so-called "dirty data."

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?

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.

In unsupervised data mining,a model or hypothesis is created ahead of time.

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Business Intelligence Systems

Filters

Exam 17: Getting Started With Web Servers, php, and the Netbeans IDE

Data warehouses are populated with data prepared by ________ programs.

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.

Market basket analysis,as described in the text,uses the statistical technique of ________.

Report authoring includes responsibility for delivery of the report.

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

Report systems include three functions: authoring,management and delivery.

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

A BI reporting system:

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of:

Problematic data include so-called "dirty data."

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?

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.

In unsupervised data mining,a model or hypothesis is created ahead of time.

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Business Intelligence Systems

Filters