Question 1

Which of the following is true of source data for a BI system?

Accepted Answer

A) It refers to the organization's metadata. 
B) It refers to data that the organization purchases from data vendors. 
C) It refers to the level of detail represented by the data. 
D) It refers to the hierarchical arrangement of criteria that predict a classification or a value. 
A) It refers to the organization's metadata. 
B) It refers to data that the organization purchases from data vendors. 
C) It refers to the level of detail represented by the data. 
D) It refers to the hierarchical arrangement of criteria that predict a classification or a value. B

Question 2

U.S.Steel Corp.is a well-known steel manufacturing company.SAMCROW, one of the customers of U.S.Steel Corp.holds an RFM score of 111.Which of the following characteristics relates SAMCROW with its RFM score?

Accepted Answer

A) SAMCROW has ordered recently and orders frequently, but it orders the least expensive goods. 
B) SAMCROW has not ordered in some time, but when it did order in the past it ordered frequently, and its orders were of the highest monetary value. 
C) SAMCROW has not ordered for some time, it did not order frequently, and, when it did order, it bought the least-expensive items. 
D) SAMCROW has ordered recently and orders frequently, and it orders the most expensive goods. 
A) SAMCROW has ordered recently and orders frequently, but it orders the least expensive goods. 
B) SAMCROW has not ordered in some time, but when it did order in the past it ordered frequently, and its orders were of the highest monetary value. 
C) SAMCROW has not ordered for some time, it did not order frequently, and, when it did order, it bought the least-expensive items. 
D) SAMCROW has ordered recently and orders frequently, and it orders the most expensive goods. D

Question 3

An ________ and an OLAP report are the same thing.

Accepted Answer

A) OLAP measure 
B) OLAP cube 
C) OLAP dimension 
D) OLAP array 
A) OLAP measure 
B) OLAP cube 
C) OLAP dimension 
D) OLAP array B

Question 4

The remarkable characteristic of OLAP reports is that they are dynamic.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following shows the products that customers tend to buy together?

Accepted Answer

A) regression analysis 
B) market-basket analysis 
C) neural networks 
D) cluster analysis 
A) regression analysis 
B) market-basket analysis 
C) neural networks 
D) cluster analysis

Question 6

A sales report that is current, as of the time the user accessed it on a Web server, is an example of a(n)________.

Accepted Answer

A) static report 
B) dynamic report 
C) expert system 
D) hybrid market report 
A) static report 
B) dynamic report 
C) expert system 
D) hybrid market report

Question 7

Business intelligence (BI)systems have only four of the five components of an information system: hardware, software, data, and people.

Accepted Answer

A) True 
 B)False

Question 8

How should a sales team respond to a customer who has an RFM score of 545?

Accepted Answer

A) The sales team should contact this customer immediately. 
B) The sales team should let go of this customer; the loss will be minimal. 
C) The sales team should attempt to up-sell more expensive goods to this customer. 
D) The sales team should spend more time with this customer. 
A) The sales team should contact this customer immediately. 
B) The sales team should let go of this customer; the loss will be minimal. 
C) The sales team should attempt to up-sell more expensive goods to this customer. 
D) The sales team should spend more time with this customer.

Question 9

Placing BI applications on operational servers can dramatically increase system performance.

Accepted Answer

A) True 
 B)False

Question 10

Dynamic reports are BI documents that are updated at the time they are requested.

Accepted Answer

A) True 
 B)False

Question 11

The remarkable characteristic of OLAP reports is that they are ________, as they are online and the viewer of the report can change their format.

Accepted Answer

A) extensible 
B) informal 
C) specific 
D) dynamic 
A) extensible 
B) informal 
C) specific 
D) dynamic

Question 12

In market-basket terminology, the ratio of confidence to the base probability of buying an item is called ________.

Accepted Answer

A) confidence 
B) support 
C) granularity 
D) lift 
A) confidence 
B) support 
C) granularity 
D) lift

Question 13

A common business application of decision trees is to classify loans by likelihood of default.

Accepted Answer

A) True 
 B)False

Question 14

RFM analysis is used to analyze and rank customers according to their ________.

Accepted Answer

A) purchasing patterns 
B) propensity to respond to a marketing stimulus 
C) socio-economic status 
D) motivation and needs 
A) purchasing patterns 
B) propensity to respond to a marketing stimulus 
C) socio-economic status 
D) motivation and needs

Question 15

________ records the source, format, assumptions and constraints, and other facts about the data.

Accepted Answer

A) Clickstream data 
B) Dimensional data 
C) Outsourced data 
D) Metadata 
A) Clickstream data 
B) Dimensional data 
C) Outsourced data 
D) Metadata

Question 16

Granularity is a term that refers to the level of detail represented by the data.

Accepted Answer

A) True 
 B)False

Question 17

Push publishing requires the user to request BI results.

Accepted Answer

A) True 
 B)False

Question 18

What is an RFM analysis?

Accepted Answer

RFM analysis, a technique readily implem

Question 19

It is better to have data with too coarse a granularity, than data with too fine a granularity.

Accepted Answer

A) True 
 B)False

Question 20

The five basic reporting operations that produce business intelligence can all be accomplished using SQL and basic HTML or a simple report writing tool.

Accepted Answer

A) True 
 B)False

Which of the following is true of source data for a BI system?

U.S.Steel Corp.is a well-known steel manufacturing company.SAMCROW, one of the customers of U.S.Steel Corp.holds an RFM score of 111.Which of the following characteristics relates SAMCROW with its RFM score?

An ________ and an OLAP report are the same thing.

The remarkable characteristic of OLAP reports is that they are dynamic.

Which of the following shows the products that customers tend to buy together?

A sales report that is current, as of the time the user accessed it on a Web server, is an example of a(n)________.

Business intelligence (BI)systems have only four of the five components of an information system: hardware, software, data, and people.

How should a sales team respond to a customer who has an RFM score of 545?

Placing BI applications on operational servers can dramatically increase system performance.

Dynamic reports are BI documents that are updated at the time they are requested.

The remarkable characteristic of OLAP reports is that they are ________, as they are online and the viewer of the report can change their format.

In market-basket terminology, the ratio of confidence to the base probability of buying an item is called ________.

A common business application of decision trees is to classify loans by likelihood of default.

RFM analysis is used to analyze and rank customers according to their ________.

________ records the source, format, assumptions and constraints, and other facts about the data.

Granularity is a term that refers to the level of detail represented by the data.

Push publishing requires the user to request BI results.

What is an RFM analysis?

It is better to have data with too coarse a granularity, than data with too fine a granularity.

The five basic reporting operations that produce business intelligence can all be accomplished using SQL and basic HTML or a simple report writing tool.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Database Processing

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters

Exam 9: Business Intelligence Systems

Which of the following is true of source data for a BI system?

U.S.Steel Corp.is a well-known steel manufacturing company.SAMCROW, one of the customers of U.S.Steel Corp.holds an RFM score of 111.Which of the following characteristics relates SAMCROW with its RFM score?

An ________ and an OLAP report are the same thing.

The remarkable characteristic of OLAP reports is that they are dynamic.

Which of the following shows the products that customers tend to buy together?

A sales report that is current, as of the time the user accessed it on a Web server, is an example of a(n)________.

Business intelligence (BI)systems have only four of the five components of an information system: hardware, software, data, and people.

How should a sales team respond to a customer who has an RFM score of 545?

Placing BI applications on operational servers can dramatically increase system performance.

Dynamic reports are BI documents that are updated at the time they are requested.

The remarkable characteristic of OLAP reports is that they are ________, as they are online and the viewer of the report can change their format.

In market-basket terminology, the ratio of confidence to the base probability of buying an item is called ________.

A common business application of decision trees is to classify loans by likelihood of default.

RFM analysis is used to analyze and rank customers according to their ________.

________ records the source, format, assumptions and constraints, and other facts about the data.

Granularity is a term that refers to the level of detail represented by the data.

Push publishing requires the user to request BI results.

What is an RFM analysis?

It is better to have data with too coarse a granularity, than data with too fine a granularity.

The five basic reporting operations that produce business intelligence can all be accomplished using SQL and basic HTML or a simple report writing tool.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Database Processing

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters