Question 1

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)  All of the above 
A)  cluster analysis. 
B)  OLAP. 
C)  regression analysis. 
D)  RFM analysis. 
E)  All of the above B

Question 2

What is data mining application?

Accepted Answer

A data mining application uses sophisticated statistical and mathematical techniques to do what-if analyses,forecast predicted values and facilitate decision making.In unsupervised data mining,analysts run tools against the raw data without a prior hypothesis or theory - after the analysis hypotheses and theories are created to explain the results.In supervised data mining,the analysts create the theory and hypothesis first,and then run tools on the raw data to calculate parameter values for the theoretical models.Report delivery is not as critical in data mining as it is in reporting systems.

Question 3

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Accepted Answer

A) True 
 B)False  False

Question 4

Why is operational data sometimes unusable for Business Intelligence purposes?

Accepted Answer

Data in operational databases can suffer

Question 5

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

Question 6

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 7

The reports generated by a reporting system can be classified as:

Accepted Answer

A)  static. 
B)  dynamic. 
C)  fluid. 
D)  Both A and B 
E)  All of the above 
A)  static. 
B)  dynamic. 
C)  fluid. 
D)  Both A and B 
E)  All of the above

Question 8

Which of the following are components of a data warehouse?

Accepted Answer

A)  Data extract, transform, and load (ETL) preparation programs 
B)  Data warehouse data 
C)  Data warehouse metadata 
D)  B and C 
E)  A, B and C 
A)  Data extract, transform, and load (ETL) preparation programs 
B)  Data warehouse data 
C)  Data warehouse metadata 
D)  B and C 
E)  A, B and C

Question 9

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

Accepted Answer

A)  Cluster analysis 
B)  Regression analysis 
C)  RFM analysis 
D)  Both A and B 
E)  All of the above 
A)  Cluster analysis 
B)  Regression analysis 
C)  RFM analysis 
D)  Both A and B 
E)  All of the above

Question 10

In a common form of RFM analysis,customers are sorted into ________ groups and given an associated score depending on their group.

Accepted Answer

The answer of In a common form of RFM analysis,customers...

Question 11

In a common form of RFM analysis,an RFM score of 5 1 1 means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is a reason that operational data are difficult to read?

Accepted Answer

A)  Dirty data 
B)  Missing values 
C)  Non-integrated data 
D)  Both A and B 
E)  All of the above 
A)  Dirty data 
B)  Missing values 
C)  Non-integrated data 
D)  Both A and B 
E)  All of the above

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

Most data mining techniques are simple and easy to use.

Accepted Answer

A) True 
 B)False

Question 16

A digital dashboard is an electronic display customized for an individual user.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

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

Question 20

Business Intelligence (BI)systems obtain their data by which of the following means?

Accepted Answer

A)  Read and process data from an operational database 
B)  Process extracts from operational databases 
C)  Process data purchased from data vendors 
D)  Both A and B 
E)  All of the above 
A)  Read and process data from an operational database 
B)  Process extracts from operational databases 
C)  Process data purchased from data vendors 
D)  Both A and B 
E)  All of the above

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

What is data mining application?

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Why is operational data sometimes unusable for Business Intelligence purposes?

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:

A data mart differs from a data warehouse in that:

The reports generated by a reporting system can be classified as:

Which of the following are components of a data warehouse?

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

In a common form of RFM analysis,customers are sorted into ________ groups and given an associated score depending on their group.

In a common form of RFM analysis,an RFM score of 5 1 1 means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

Which of the following is a reason that operational data are difficult to read?

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 are information systems that help users analyze and use data.

Most data mining techniques are simple and easy to use.

A digital dashboard is an electronic display customized for an individual user.

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

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

Business Intelligence (BI)systems obtain their data by which of the following means?

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

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

What is data mining application?

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Why is operational data sometimes unusable for Business Intelligence purposes?

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:

A data mart differs from a data warehouse in that:

The reports generated by a reporting system can be classified as:

Which of the following are components of a data warehouse?

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

In a common form of RFM analysis,customers are sorted into ________ groups and given an associated score depending on their group.

In a common form of RFM analysis,an RFM score of 5 1 1 means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

Which of the following is a reason that operational data are difficult to read?

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 are information systems that help users analyze and use data.

Most data mining techniques are simple and easy to use.

A digital dashboard is an electronic display customized for an individual user.

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

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

Business Intelligence (BI)systems obtain their data by which of the following means?

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