Deck 10: Information Systems Security

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

Problematic data are termed dirty data.

Question 6

Operational data is structured for fast and reliable transaction processing.

Question 7

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

Question 8

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

Question 9

Data mart is another term used for a data warehouse.

Question 10

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

Question 11

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

Question 12

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

Question 13

Report servers are specialized Web servers.

Question 14

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 15

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

Question 16

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

Question 17

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

Question 18

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 19

Push publishing requires the user to request BI results.

Question 20

Data acquisition is the process of creating business intelligence.

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

A decision tree analysis is a supervised data mining technique.

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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 38

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

Question 39

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

Question 40

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

Question 41

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

Question 42

Problematic operational data are termed ________.

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

Question 43

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

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

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

Question 46

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

Question 47

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

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

Question 48

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 49

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

Question 50

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

Question 51

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

Question 52

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

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

Question 53

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

Question 54

Because of the various problems with operational data, large organizations choose to extract operational data and typically create and staff a group of people who manage and run a(n) ________.

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

Question 55

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

Question 56

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

Question 57

________ requires the user to request BI results.

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

Question 58

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

Question 59

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 60

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

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.

Question 62

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 63

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 64

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 65

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's RFM score is most likely ________.

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

Question 66

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 67

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 68

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

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

Question 69

OLAP stands for ________.

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

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 an example of a measure in an OLAP report?

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

Question 73

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 74

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

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

Question 75

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 76

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

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

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

Question 78

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 79

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 80

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