Deck 9: Business Intelligence Systems

Question 1

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

Answer 1

False

Question 2

A data mart is a data collection that addresses a particular functional area of the business.

Answer 2

True

Question 3

The software component of a BI system is called a BI application.

Answer 3

True

Question 4

It is possible to capture the customers' clicking behavior using clickstream data.

Question 5

The three primary activities in the BI process are to acquire data, perform analysis, and publish results.

Question 6

The three fundamental categories of BI analysis are reporting, data mining, Big data and knowledge management.

Question 7

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

Question 8

Data acquisition is the process of creating business intelligence.

Question 9

Problematic data are termed dirty data.

Question 10

A value of 999-999-9999 for a U.S.phone number is an example of dirty data for BI purpose.

Question 11

A reporting application is a BI application that inputs data from one or more sources and applies reporting operations to that data to produce business intelligence.

Question 12

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

Question 13

Operational data is structured for fast and reliable transaction processing.

Question 14

Push publishing requires the user to request BI results.

Question 15

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

Question 16

Data warehouses do not include data that are purchased from outside sources.

Question 17

Report servers are specialized Web servers.

Question 18

Data mart is another term used for a data warehouse.

Question 19

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

Question 20

A data mart is a lot larger than a data warehouse.

Question 21

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

Question 22

Data mining is the application of statistical techniques to find patterns and relationships among data for classification and prediction.

Question 23

A drawback associated with OLAP reports is their inability to let users drill down into the data.

Question 24

Cluster analysis is used to identify groups of entities that have similar characteristics.

Question 25

In market-basket terminology, confidence is the probability that two items will be purchased together.

Question 26

Knowledge discovery in databases (KDD)is used as a synonym for data mining.

Question 27

An OLAP cube and an OLAP report are the same thing.

Question 28

In market-basket terminology, a conditional probability estimate is called lift.

Question 29

Total sales, average sales, and average cost are examples of dimensions used in an OLAP report.

Question 30

With unsupervised data mining, analysts do not create a model or hypothesis before running the analysis.

Question 31

Neural networks are a popular unsupervised data mining technique used to predict values and make classifications.

Question 32

RFM analysis considers how recently (R)a customer ordered, how frequently (F)they ordered, and how much margin (M)the company made on the orders.

Question 33

Regression analysis measures the effect of a set of variables on another variable.

Question 34

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

Question 35

MapReduce is a technique for harnessing the power of thousands of computers working in parallel.

Question 36

A decision tree analysis is a supervised data mining technique.

Question 37

In marketing transactions, the fact that customers who buy product X also buy product Y creates a cross-selling opportunity.

Question 38

In supervised data mining, a model is developed after the analysis.

Question 39

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

Question 40

In an OLAP report, a measure is the data item of interest.

Question 41

Expert systems are rule-based systems that use "If ...then" rules unlike those created by decision tree analysis.

Question 42

________ requires the user to request BI results.

A)Push publishing
B)Pull publishing
C)Desktop publishing
D)Accessible publishing

Question 43

Because of the various problems with operational data, large organizations choose to extract operational data and store them into a(n)________.

A)OLAP cube
B)neural network
C)data warehouse
D)Web server

Question 44

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

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.

Question 45

All management data needed by any of the BI servers is stored in metadata.

Question 46

In expert systems, the programs that process a set of rules are called expert systems shells.

Question 47

Problematic operational data are termed ________.

A)bad data
B)rough data
C)dirty data
D)granular data

Question 48

Which of the following is a fundamental category of BI analysis?

A)automation
B)catalog
C)report servers
D)data mining

Question 49

________ is defined as information containing patterns, relationships, and trends of various forms of data.

A)Process mining
B)Business process management
C)Business intelligence
D)Spatial intelligence

Question 50

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

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

Question 51

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

A)Granularity
B)Intricacy
C)Elaboration
D)Complexity

Question 52

Knowledge management was done only after the advent of social media.

Question 53

Data ________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data.

A)entry
B)acquisition
C)mining
D)encryption

Question 54

KM fosters innovation by encouraging the free flow of ideas.

Question 55

Hadoop is an open-source program supported by the Apache Foundation4 that implements MapReduce on potentially thousands of computers.

Question 56

A sales report that is current as of the time the user accessed it on a Web server is a static report.

Question 57

Push publishing delivers business intelligence ________.

A)according to a schedule or as a result of an event or particular data condition
B)through reporting, data mining, and knowledge management
C)by obtaining, cleaning, organizing, relating, and cataloging source data
D)in response to requests from users

Question 58

Static reports are BI documents that are fixed at the time of creation and do not change.

Question 59

A BI server extends alert/RSS functionality to support user subscriptions.

Question 60

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

Question 61

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

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

Question 62

Ajax is one of the customers of a well-known linen manufacturing company.Ajax has not ordered linen in some time, but when it did order in the past it ordered frequently, and its orders were of the highest monetary value.Under the given circumstances, Ajax's RFM score is most likely ________.

A)155
B)511
C)555
D)151

Question 63

An ________ and an OLAP report are the same thing.

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

Question 64

A data ________ is a data collection, smaller than the data warehouse, that addresses a particular department or functional area of the business.

A)mart
B)mine
C)cube
D)model

Question 65

The viewer of an OLAP report can change its format.Which term implies this capability?

A)processing
B)analytical
C)dimension
D)online

Question 66

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

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 67

Which of the following statements is true about operational data?

A)It is always better to have data with too coarse a granularity than with too fine a granularity.
B)If the data granularity is too coarse, the data can be made finer by summing and combining.
C)Purchased operational data often contains missing elements.
D)Problematic operational data are termed rough data.

Question 68

Which of the following statements is true about data marts?

A)A data mart is like a distributor in a supply chain, while a data warehouse can be compared to a retail store.
B)Data mart users possess the data management expertise that data warehouse employees have.
C)Data marts address only a particular component or functional area of a business.
D)Data marts are larger than data warehouses.

Question 69

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?

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.

Question 70

________ analysis is a way of analyzing and ranking customers according to their purchasing patterns.

A)TQM
B)CRM
C)Market-basket
D)RFM

Question 71

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

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

Question 72

Due to a phenomenon called the ________, the more attributes there are, the easier it is to build a model that fits the sample data but that is worthless as a predictor.

A)attribute paradox
B)curse of dimensionality
C)uncertainty principle
D)economies of scale

Question 73

An OLAP report has measures and dimensions.Which of the following is an example of a dimension?

A)total sales
B)average sales
C)sales region
D)average cost

Question 74

A ________ takes data from the data manufacturers, cleans and processes the data, and then stores it.

A)data mart
B)data mine
C)data warehouse
D)data model

Question 75

OLAP stands for ________.

A)online analytical processing
B)object-based lead analysis procedure
C)object-oriented analytical protocol
D)organizational lead analysis process

Question 76

Which of the following is an example of a measure in an OLAP report?

A)customer type
B)purchase date
C)sales region
D)average cost

Question 77

A sales team should attempt to up-sell more expensive products to a customer who has an RFM score of ________.

A)311
B)555
C)113
D)545

Question 78

Which of the following accurately defines a dimension in an OLAP report?

A)It is a characteristic of a measure.
B)It is the item that is processed in the OLAP report.
C)It is the data item of interest.
D)It is referred to as a decision tree.

Question 79

Which of the following is a basic operation used by reporting tools to produce information from data?

A)coalescing
B)transposing
C)dispersing
D)calculating

Question 80

Which of the following statements is true about reporting applications?

A)Reporting applications deliver business intelligence to users as a result of an event or particular data condition.
B)Reporting applications consist of five standard components: hardware, software, data, procedures, and people.
C)Two important reporting applications are RFM analysis and OLAP.
D)Reporting applications produce business intelligence using highly sophisticated operations.