Question 1

What is a data warehouse?

Accepted Answer

A data warehouse is a non-operational da

Question 2

What are Business Intelligence (BI)systems?

Accepted Answer

Business Intelligence (BI)systems are in

Question 3

Business Intelligence (BI)systems obtain data in ________ different ways.

Accepted Answer

The answer of Business Intelligence (BI)systems obtain data in ________...

Question 4

A data warehouse database differs from an operational database because:

Accepted Answer

A) data warehouse data are not stored in tables. 
B) data warehouse databases do not have metadata. 
C) data warehouse data are often stored in a dimensional database. 
D) Both B and C 
E) All of the above 
A) data warehouse data are not stored in tables. 
B) data warehouse databases do not have metadata. 
C) data warehouse data are often stored in a dimensional database. 
D) Both B and C 
E) All of the above

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."

Accepted Answer

A) True 
 B)False

Question 8

The reports generated by a reporting system can be delivered in which of the following media?

Accepted Answer

A) Paper 
B) Web portal 
C) Digital dashboard 
D) E-mail 
E) All of the above 
A) Paper 
B) Web portal 
C) Digital dashboard 
D) E-mail 
E) All of the above

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

Report delivery is more important for data mining than it is for reporting systems.

Accepted Answer

A) True 
 B)False

Question 12

What is a star schema?

Accepted Answer

The star schema describes the arrangemen

Question 13

In a common form of RFM analysis,customers with an F score of ________ are in the 20% of customers who have the most frequent orders.

Accepted Answer

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

Question 14

A(n)________ is an information system that helps users analyze and use data.

Accepted Answer

Business I

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

Problematic data include so-called "dirty data."

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What is data mining application?

Accepted Answer

A data mining application uses sophistic

Question 20

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

What is a data warehouse?

What are Business Intelligence (BI)systems?

Business Intelligence (BI)systems obtain data in ________ different ways.

A data warehouse database differs from an operational database because:

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

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,a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."

The reports generated by a reporting system can be delivered in which of the following media?

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

Report delivery is more important for data mining than it is for reporting systems.

What is a star schema?

In a common form of RFM analysis,customers with an F score of ________ are in the 20% of customers who have the most frequent orders.

A(n)________ is an information system that helps users analyze and use data.

The metadata maintained by a reporting system database describes:

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

Problematic data include so-called "dirty data."

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

What is data mining application?

A data mart differs from a data warehouse in that:

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

What is a data warehouse?

What are Business Intelligence (BI)systems?

Business Intelligence (BI)systems obtain data in ________ different ways.

A data warehouse database differs from an operational database because:

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

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,a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."

The reports generated by a reporting system can be delivered in which of the following media?

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

Report delivery is more important for data mining than it is for reporting systems.

What is a star schema?

In a common form of RFM analysis,customers with an F score of ________ are in the 20% of customers who have the most frequent orders.

A(n)________ is an information system that helps users analyze and use data.

The metadata maintained by a reporting system database describes:

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

Problematic data include so-called "dirty data."

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

What is data mining application?

A data mart differs from a data warehouse in that:

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