Deck 9: Business Intelligence Systems

Question 1

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

Answer 1

True

Question 2

Placing business intelligence (BI) applications on operational servers can dramatically increase system performance.

Answer 2

False

Question 3

Problematic data is termed as dirty data.

Answer 3

True

Question 4

The four fundamental categories of business intelligence (BI) analysis are reporting, data mining, BigData, and knowledge management.

Question 5

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

Question 6

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

Question 7

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

Question 8

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 9

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

Question 10

A data mart is larger than a data warehouse.

Question 11

Push publishing delivers business intelligence only on request from the users.

Question 12

Operational data is structured for fast and reliable transaction processing.

Question 13

The software component of a business intelligence (BI) system is called a BI application.

Question 14

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

Question 15

A value of 999-999-9999 for a U.S. phone number is an example of dirty data for business intelligence (BI) purposes.

Question 16

Report servers are specialized Web servers.

Question 17

Data acquisition is the process of creating business intelligence.

Question 18

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

Question 19

Data mart is another term used for a data warehouse.

Question 20

Business intelligence (BI) systems have four standard components called hardware, software, data, and procedures.

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

RFM analysis considers how recently (R) a customer ordered, how fast (F) the order was delivered, and how much margin (M) the company made on the order.

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

A decision tree analysis is a supervised data mining technique.

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

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

Question 42

All management data needed by any of the business intelligence (BI) servers is stored in metadata.

Question 43

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 44

Which of the following statements is True of source data for a business intelligence (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 detailed level of data.
D) It refers to the hierarchical arrangement of criteria that predict a classification or a value.

Question 45

Expert systems are rule-based systems that encode human knowledge in the form of If/ Then rules.

Question 46

Dynamic reports are business intelligence (BI) documents that are updated at the time they are requested.

Question 47

A business intelligence (BI) server extends alert/RSS functionality to support user subscriptions.

Question 48

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

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

Question 50

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

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

Question 51

Problematic operational data is termed as ________.

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

Question 52

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

Question 53

In large organizations, a group of people manage and run a(n) ________, which is a facility for managing an organization's BI data.

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

Question 54

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

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

Question 55

Which of the following is a fundamental category of business intelligence (BI) analysis?

A) automation
B) encapsulation
C) data hiding
D) data mining

Question 56

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

Question 57

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

Question 58

________ requires the user to request business intelligence (BI) results.

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

Question 59

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

Question 60

Knowledge management is the process of creating value from intellectual capital and sharing that knowledge with those who need it.

Question 61

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 the needs of a particular department or functional area of a business.
D) Data marts are larger than data warehouses.

Question 62

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

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

Question 63

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

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

Question 64

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

A) 311
B) 551
C) 113
D) 542

Question 65

Which of the following phenomena states that the more attributes there are, the easier it is to build a model that fits the sample data?

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

Question 66

A ________ takes data from the data manufacturers, cleans and processes the data, and locates the data on the shelves.

A) data link layer
B) data mine
C) data warehouse
D) data model

Question 67

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, for 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 68

Ajax Inc. 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 is most likely to have an RFM score of ________.

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

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 anything for a while, 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 anything for a while and it did not order frequently, but 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

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 71

An ________ and an OLAP report are the same thing.

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

Question 72

Which of the following is a basic operation used by reporting applications to produce business intelligence?

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

Question 73

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 is termed rough data.

Question 74

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) accurate
B) informal
C) specific
D) dynamic

Question 75

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) Reporting applications refer to business applications that input data from one or more sources and applies reporting operations to that data to produce business intelligence.
D) Reporting applications produce business intelligence using highly sophisticated operations.

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

OLAP stands for ________.

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

Question 78

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

A) Regression analysis
B) CRM
C) Market-basket
D) RFM

Question 79

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

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

Question 80

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

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