MIS CHAPTER 9

34) Which of the following is true of unsupervised data mining? A) Analysts do not create a model or hypothesis before running the analysis. B) Neural networks is a popular unsupervised data mining application. C) Unsupervised data mining requires tools such as regression analysis. D) Unsupervised data mining requires analysts to fit data to suggested hypotheses.

A) Analysts do not create a model or hypothesis before running the analysis.

46) The world's best-known indexing engine is operated by ________. A) Google B) Yahoo C) Microsoft D) Oracle

A) Google

10) ________ is a term used to refer to the level of detail represented by the data. A) Granularity B) Intricacy C) Elaboration D) Complexity

A) Granularity

28) Which of the following describes 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.

A) It is a characteristic of a measure.

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

A) according to a schedule or as a result of an event or particular data condition

39) In marketing transactions, the fact that customers who buy product X also buy product Y creates a(n) ________ opportunity. That is, "If they're buying X, sell them Y," or "If they're buying Y, sell them X." A) cross-selling B) value added selling C) break-even D) portfolio

A) cross-selling

14) A data ________ is a data collection, smaller than the data warehouse that addresses a particular component or functional area of the business. A) mart B) mine C) cube D) model

A) mart

24) OLAP stands for ________. A) online analytical processing B) object-based lead analysis procedure C) object-oriented analytical protocol D) organizational lead analysis process

A) online analytical processing

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

A) purchasing patterns

40) In market-basket terminology, ________ is the term that describes the probability that two items will be purchased together. A) support B) confidence C) lift D) dimension

A) support

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

B) 511

49) ________ attempt to capture human expertise and put it into a format that can be used by non experts. A) Neural networks B) Expert systems C) Regression analysis D) Decision trees

B) Expert systems

2) 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.

B) It refers to data that the organization purchases from data vendors.

43) ________ is the process of creating value from intellectual capital and sharing that knowledge with employees, managers, suppliers, customers, and others who need it. A) Intellectual property protection B) Knowledge management C) Business Process Reengineering D) Repository management

B) Knowledge management

30) An ________ and an OLAP report are the same thing. A) OLAP measure B) OLAP cube C) OLAP dimension D) OLAP array

B) OLAP cube

31) Which of the following observations about RFM and OLAP reports is true? A) RFM is more generic than OLAP. B) OLAP reports are more dynamic than RFM reports. C) RFM reports have measures and dimensions. D) RFM reports can drill down into the data.

B) OLAP reports are more dynamic than RFM reports.

6) ________ requires the user to request BI results. A) Push publishing B) Pull publishing C) Desktop publishing D) Accessible publishing

B) Pull publishing

48) With a(n) ________ , users can subscribe to content sources and be notified when they have been changed. A) BI server B) RSS reader C) KM protocol D) expert system

B) RSS reader

23) 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.

B) The sales team should let go of this customer; the loss will be minimal.

3) Data ________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data. A) entry B) acquisition C) mining D) encryption

B) acquisition

35) With ________, statistical techniques can identify groups of entities that have similar characteristics. A) regression analysis B) cluster analysis C) expert systems D) neural networks

B) cluster analysis

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

B) curse of dimensionality

51) A sales report that is current, as of the time the user accessed it on a Web server, is an example of a(n) ________. A) static reports B) dynamic report C) expert system D) market-basket analysis

B) dynamic report

38) Which of the following is used to show the products that customers tend to buy together? A) regression analysis B) market-basket analysis C) neural networks D) cluster analysis

B) market-basket analysis

54) BI servers use ________ to determine what results to send to which users and on which schedule. A) expert systems B) metadata C) RSS feeds D) neural networks

B) metadata

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

C) 113

42) ________ is a hierarchical arrangement of criteria that predict a classification or a value. A) A value chain B) A cluster analysis C) A decision tree D) A neural network

C) A decision tree

53) Which of the following statements is true about BI publishing alternatives? A) Most dynamic reports are published as PDF documents. B) For Web servers and SharePoint, the push option is mandatory. C) BI servers extend alert/RSS functionality to support user subscriptions. D) Publishing static BI content requires more skill, compared to publishing dynamic BI content.

C) BI servers extend alert/RSS functionality to support user subscriptions.

1) ________ is defined as information containing patterns, relationships, and trends. A) Process mining B) Business process management C) Business intelligence D) Spatial intelligence

C) Business intelligence

15) 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.

C) Data marts address only a particular component or functional area of a business.

32) ________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction. A) Data optimization B) Database normalization C) Data mining D) Data warehousing

C) Data mining

45) ________ is the single most important content function in knowledge management applications. A) Sourcing B) Retrieving C) Indexing D) Sorting

C) Indexing

52) The ________ is the most popular BI server today. A) Microsoft Azure B) Microsoft Windows Vista Professional C) Microsoft SQL Server Report manager D) Microsoft Dynamics Solomon

C) Microsoft SQL Server Report manager

11) 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.

C) Purchased operational data often contains missing elements.

47) ________ is a standard for subscribing to content sources. A) Knowledge Discovery in Databases (KDD) B) Online Analytical Processing (OLAP) C) Real Simple Syndication (RSS) D) Data Transfer Protocol (DTP)

C) Real Simple Syndication (RSS)

16) 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.

C) Two important reporting applications are RFM analysis and OLAP.

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

C) data warehouse

7) Because of the various problems with operational data, large organizations choose to extract operational data into a(n) ________. A) OLAP cube B) neural network C) data warehouse D) Web server

C) data warehouse

9) Problematic operational data are termed ________. A) bad data B) rough data C) dirty data D) granular data

C) dirty data

33) Which of the following terms is used as a synonym for data mining? A) regression analysis B) data warehousing C) knowledge discovery in databases D) parallel processing

C) knowledge discovery in databases

37) Which of the following is an example of a supervised data-mining technique? A) cluster analysis B) market-basket analysis C) regression analysis D) click streaming

C) regression analysis

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

C) sales region

36) With ________, data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model. A) cluster analysis B) unsupervised data mining C) supervised data mining D) click streaming

C) supervised data mining

8) ________ records the source, format, assumptions and constraints, and other facts about the data. A) Clickstream data B) Dimensional data C) Outsourced data D) Metadata

D) Metadata

18) ________ analysis is a way of analyzing and ranking customers according to their purchasing patterns. A) TQM B) CRM C) Market-basket D) RFM

D) RFM

20) 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.

D) SAMCROW has ordered recently and orders frequently, and it orders the most expensive goods.

50) Which of the following observations concerning expert systems is true? A) The "If...then" rules used in these systems are created by mining data. B) They have lived up to the high expectations set by their name. C) They typically have fewer than a dozen rules. D) They are difficult and expensive to develop.

D) They are difficult and expensive to develop.

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

D) average cost

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

D) calculating

4) Which of the following is a fundamental category of BI analysis? A) automation B) catalog C) report servers D) data mining

D) data mining

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

D) dynamic

44) Which of the following is a major category of knowledge assets? A) distributors B) suppliers C) customers D) employees

D) employees

41) In market-basket terminology, the ratio of confidence to the base probability of buying an item is called the ________. A) confidence B) support C) granularity D) lift

D) lift

25) The viewer of an OLAP report can change its format. Which term implies this capability? A) processing B) analytical C) dimension D) online

D) online