ISM ch 9

Which of the following statements is true of a data warehouse? A) A data warehouse is larger than a data mart. B) A data warehouse functions like a retail store in a supply chain. C) Users in a data warehouse obtain data pertaining to a business function from a data mart. D) Data analysts who work with a data warehouse are experts in a particular business function.

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

________ is an unsupervised data mining technique in which statistical techniques identify groups of entities that have similar characteristics. A) Cluster analysis B) Content indexing C) Regression analysis D) Cloud computing

A) Cluster analysis

Which of the following statements is true of enterprise resource planning (ERP) application programs? A) During the ERP development process, the development team sets configuration parameters that specify how ERP application programs will operate. B) There are virtually no limits to how much configuration can be done in an ERP application program. C) Custom programming of ERP application programs are economical both initially and for long-term maintenance. D) In order to meet varying customer requirements, development teams must often change the program code of ERP application programs.

A) During the ERP development process, the development team sets configuration parameters that specify how ERP application programs will operate.

________ is a suite of applications, a database, and a set of inherent processes for consolidating business operations into a single, consistent computing platform. A) Enterprise resource planning B) Customer relationship management C) Warehouse management system D) Supply chain management

A) Enterprise resource planning

________ are reports produced when something out of predefined bounds occurs. A) Exception reports B) Static reports C) Dynamic reports D) Subscription reports

A) Exception reports

Which of the following statements is true of the effect of enterprise resource planning (ERP) on the IT staff of midsized organizations? A) In midsized organizations, the IT staff is often isolated from senior management. B) ERP implementation in midsized companies will be part of a strategic process and, once begun, will have the full backing of the entire executive group. C) IT specialists in midsized organizations are spread very thin and often are in over their heads during an ERP implementation. D) Midsized organizations employ only one or two IT specialists.

A) In midsized organizations, the IT staff is often isolated from senior management.

________ is the process of delivering business intelligence to users without any request from the users. A) Push publishing B) Pull publishing C) Data acquisition D) Data mining

A) Push publishing

________ are user requests for particular business intelligence results on a particular schedule or in response to particular events. A) Subscriptions B) Third-party cookies C) Static reports D) Dynamic reports

A) Subscriptions

Which of the following is a fundamental category of business intelligence (BI) analysis? A) data acquisition B) reporting C) push publishing D) pull publishing

A) data acquisition

A ________ is a data collection, smaller than the data warehouse that addresses the needs of a particular department or functional area of a business. A) data mart B) data room C) datasheet D) dataspace

A) data mart

The source, format, assumptions and constraints, and other facts concerning certain data are called ________. A) metadata B) data structures C) microdata D) network packets

A) metadata

Which of the following statements is true of unsupervised data mining? A) Analysts apply unsupervised data mining techniques to estimate the parameters of a developed model. B) Analysts create hypotheses only after performing an analysis. C) Regression analysis is the most commonly used unsupervised data mining technique. D) Data miners develop models prior to performing an analysis.

B) Analysts create hypotheses only after performing an analysis.

________ refers to the level of detail represented by data. A) Abstraction B) Granularity C) Dimensionality D) Aggregation

B) Granularity

Which of the following statements is true of data with granularity? A) It can be too fine or too coarse and also have wrong granularity. B) If granularity is too coarse, data can be made finer by summing and combining. C) It is not possible to have a wrong granularity for a data. D) If granularity is too coarse, data can be separated into constituent parts using regression.

B) If granularity is too coarse, data can be made finer by summing and combining.

Which of the following statements is true of business intelligence (BI) publishing alternatives? A) The skills required to publish static content are extremely high. B) Publishing dynamic BI is more difficult than publishing static content. C) For static content, the skill required to create a publishing application is high. D) For Web servers, push options are manual.

B) Publishing dynamic BI is more difficult than publishing static content.

________ requires users to request business intelligence results. A) Push publishing B) Pull publishing C) Data acquisition D) Data mining

B) Pull publishing

The process of maintaining a general ledger, which must be integrated into applications in order to form a true enterprise resource planning (ERP) product, is a(n) ________ activity. A) supply chain B) accounting C) human resources D) manufacturing

B) accounting

Which of the following is a manufacturing activity that must be included in a true enterprise resource planning (ERP) product? A) supplier management B) capacity planning C) sales prospecting D) procurement

B) capacity planning

Which of the following refers to data in the form of rows and columns? A) granulated data B) structured data C) micro data D) coarse data

B) structured data

In the case of ________, data miners develop models prior to conducting analyses and then apply statistical techniques to data to estimate parameters of the models. A) pull publishing techniques B) supervised data mining C) push publishing techniques D) unsupervised data mining

B) supervised data mining

The more attributes there are in a sample data, the easier it is to build a model that fits the sample data, but that is worthless as a predictor. Which of the following best explains this phenomenon? A) the free rider problem B) the curse of dimensionality C) the tragedy of the commons D) the zero-sum game

B) the curse of dimensionality

Which of the following statements is true of an enterprise resource planning (ERP) database? A) An ERP solution contains the company's operational data. B) A stored procedure is a computer program code stored within an ERP database that runs to keep the database consistent when certain conditions arise. C) An ERP solution includes initial configuration data. D) A trigger is a computer program code stored in an ERP database that is used to enforce business rules.

C) An ERP solution includes initial configuration data.

________ process operational and other data in organizations to analyze past performance and make predictions. A) Virtualization techniques B) Live migration techniques C) Business intelligence systems D) Windowing systems

C) Business intelligence systems

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

C) Data mining

________ techniques emerged from the combined discipline of statistics, mathematics, artificial intelligence, and machine-learning. A) Push publishing B) Pull publishing C) Data mining D) Exception reporting

C) Data mining

________ activities include payroll, time and attendance, and benefits administration that must be integrated into applications in order to form a true enterprise resource planning (ERP) product. A) Manufacturing B) Supply chain C) Human resource D) Accounting

C) Human resource

What is a stored procedure? A) It is a computer program stored within a database that runs to keep the database consistent when certain conditions arise. B) It is an area of memory that is used for dynamic memory allocation. C) It is a computer program stored in a database that is used to enforce business rules. D) It is a software program that houses and serves business logic for use by multiple applications.

C) It is a computer program stored in a database that is used to enforce business rules.

________ are business intelligence documents that are fixed at the time of creation and do not change. A) Critical reports B) Dynamic reports C) Static reports D) Exception reports

C) Static reports

Which of the following aspects that impact enterprise resource planning (ERP) differs among companies of different sizes? A) relevance of ERP systems B) value chains C) availability of skilled IT staff D) basic business processes

C) availability of skilled IT staff

A ________ is a facility for managing an organization's business intelligence data. A) datasheet B) dataspace C) data warehouse D) data table

C) data warehouse

Which of the following is an example of a supply chain activity? A) capacity planning B) marketing C) inventory management D) customer management

C) inventory management

Which of the following problems is particularly common for data that have been gathered over time? A) wrong granularity B) lack of integration C) lack of consistency D) missing values

C) lack of consistency

Which of the following activities in the business intelligence process involves delivering business intelligence to the knowledge workers who need it? A) data acquisition B) BI analysis C) publish results D) data mining

C) publish results

The goal of ________, a type of business intelligence analysis, is to create information about past performance. A) push publishing B) data mining C) reporting analyses D) BigData

C) reporting analyses

The use of an organization's operational data as the source data for a business intelligence system is not usually recommended because it ________. A) is not possible to create reports based on operational data B) is not possible to perform business intelligence analyses on operational data C) requires considerable processing and can drastically reduce system performance D) considers only the external data and not the internal data regarding the organization's functions

C) requires considerable processing and can drastically reduce system performance

Customer relationship management (CRM), as an application that must be included in a true enterprise resource planning (ERP) product, includes ________. A) cash management B) HR management C) sales prospecting D) capacity planning

C) sales prospecting

Regression analysis is used in ________. A) progress reporting B) bug reporting C) supervised data mining D) unsupervised data mining

C) supervised data mining

Which of the following statements is true of BigData? A) BigData contains only structured data. B) BigData has low velocity and is generated slowly. C) BigData cannot store graphics, audio, and video files. D) BigData refers to data sets that are at least a petabyte in size.

D) BigData refers to data sets that are at least a petabyte in size.

Which of the following statements is true of business intelligence (BI) systems? A) Business intelligence systems are primarily used for developing software systems and data mining applications. B) The four standard components of business intelligence systems are software, procedures, applications, and programs. C) The software component of a business intelligence system is called an intelligence database. D) Business intelligence systems analyze an organization's past performance to make predictions.

D) Business intelligence systems analyze an organization's past performance to make predictions.

________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data. A) Data manipulation B) BI analysis C) Publish results D) Data acquisition

D) Data acquisition

________ reports are business intelligence documents that are updated at the time they are requested. A) Subscription B) Third-party cookie C) Static D) Dynamic

D) Dynamic

Which of the following statements is true of the impact of enterprise resource planning (ERP) on the IT staff of small organizations? A) IT specialists in small organizations are dedicated to managing only the ERP system. B) The IT staff in small organizations is isolated from senior management. C) The chief information officer obtains the backing of the entire executive group for ERP implementation. D) IT specialists in small organizations are spread very thin and often are in over their heads during an ERP implementation.

D) IT specialists in small organizations are spread very thin and often are in over their heads during an ERP implementation.

________ is used to measure the impact of a set of variables on another variable during data mining. A) Cluster analysis B) Context indexing C) Cloud computing D) Regression analysis

D) Regression analysis

________ is the process of sorting, grouping, summing, filtering, and formatting structured data. A) Push publishing B) Publish results C) Cloud computing D) Reporting analysis

D) Reporting analysis

A ________ is designed to extract data from operational systems and other sources, clean the data, and store and catalog that data for processing by business intelligence tools. A) data mart B) data center C) data room D) data warehouse

D) data warehouse

Users in a data mart obtain data that pertain to a particular business function from a ________. A) data room B) data center C) datasheet D) data warehouse

D) data warehouse

Problematic data are termed ________. A) random data B) macro data C) vague data D) dirty data

D) dirty data

The ________ of business intelligence servers maintains metadata about the authorized allocation of business intelligence results to users. A) exception report B) dynamic report C) delivery function D) management function

D) management function