Question 1

A reporting system does not maintain a database of metadata.

Accepted Answer

A) True 
 B)False

Question 2

OLAP stands for:

Accepted Answer

A) Online Analytical Processing. 
B) Offline Analytical Processing. 
C) Online Analysis Process. 
D) Offline Analysis Process. 
E) Old,Lazy And Particular. 
A) Online Analytical Processing. 
B) Offline Analytical Processing. 
C) Online Analysis Process. 
D) Offline Analysis Process. 
E) Old,Lazy And Particular.

Question 3

A report that is sent to users on a predetermined schedule is called a(n)________ report.

Accepted Answer

The answer of A report that is sent to users...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Here is Market Basket data for 1,000 transactions at a Drug Store.Use the table below to answer the following questions.
 $\begin{array}{|c|c|c|c}
\hline \begin{array}{c}
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 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 
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 6

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 7

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 8

Data warehouses are populated with data prepared by ________ programs.

Accepted Answer

Extract,Tr

Question 9

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 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

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

Accepted Answer

onditional

Question 15

Reports that do not change once prepared are called static reports.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

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

Accepted Answer

A) True 
 B)False

A reporting system does not maintain a database of metadata.

OLAP stands for:

A report that is sent to users on a predetermined schedule is called a(n)________ report.

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

Market basket analysis is:

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

Data warehouses are populated with data prepared by ________ programs.

Which of the following are components of a data warehouse?

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

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

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

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

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

Reports that do not change once prepared are called static reports.

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

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

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

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Big Data

Filters

Exam 17: Business Intelligence Systems

A reporting system does not maintain a database of metadata.

OLAP stands for:

A report that is sent to users on a predetermined schedule is called a(n)________ report.

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

Market basket analysis is:

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

Data warehouses are populated with data prepared by ________ programs.

Which of the following are components of a data warehouse?

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

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

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

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

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

Reports that do not change once prepared are called static reports.

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

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

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

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Big Data

Filters