Question 1

In unsupervised data mining,explanations are created after patterns are found.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

What is a data warehouse?

Accepted Answer

A data warehouse is a non-operational da

Question 5

A(n)________ is a collection of data that addresses a particular component or functional area of a business.

Accepted Answer

The answer of A(n)________ is a collection of data that...

Question 6

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)  Both A and B 
E)  A, B and C 
A)  Decision tree analysis 
B)  Logistic regression analysis 
C)  Neural networks 
D)  Both A and B 
E)  A, B and C

Question 7

Business Intelligence (BI)systems support operational activities.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

A reporting system does not maintain a database of metadata.

Accepted Answer

A) True 
 B)False

Question 10

________ provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

Accepted Answer

The answer of ________ provides the ability to sum,count,average and...

Question 11

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 
E)  None of the above is correct. 
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 
E)  None of the above is correct.

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

Question 13

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 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Report modes include dynamic and static.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

The answer of Business Intelligence (BI)________ are used to filter...

Question 20

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

Accepted Answer

A)  Creating reports 
B)  Perform what-if analysis 
C)  Make predictions 
D)  Facilitate decision making 
E)  Perform data analyses using complex mathematical processing 
A)  Creating reports 
B)  Perform what-if analysis 
C)  Make predictions 
D)  Facilitate decision making 
E)  Perform data analyses using complex mathematical processing

In unsupervised data mining,explanations are created after patterns are found.

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.

What is a data warehouse?

A(n)________ is a collection of data that addresses a particular component or functional area of a business.

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

Business Intelligence (BI)systems support operational activities.

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

A reporting system does not maintain a database of metadata.

________ provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

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

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

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

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

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

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

Report modes include dynamic and static.

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

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

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 17: Learn the basic concepts of business intelligence (BI)systems

In unsupervised data mining,explanations are created after patterns are found.

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.

What is a data warehouse?

A(n)________ is a collection of data that addresses a particular component or functional area of a business.

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

Business Intelligence (BI)systems support operational activities.

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

A reporting system does not maintain a database of metadata.

________ provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

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

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

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

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

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

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

Report modes include dynamic and static.

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

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

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn about replicated partitioned data stores for supporting clusters

Filters

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