ISBC 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

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

A) Exception reports

Which of the following statements is true of data with granularity? A) Granularity refers to the level of detail represented by the data. B) If granularity is too coarse, data can be made finer by summing and combining. C) The granularity of clickstream data is too coarse. D) If granularity is too coarse, data can be separated into constituent parts using regression.

A) Granularity refers to the level of detail represented by the data.

________ is an open-source program supported by the Apache Foundation that manages thousands of computers and implements MapReduce. A) Hadoop B) BigData C) Linux D) Apache Wave

A) Hadoop

________ 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

A ________ is a data collection 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, 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 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 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

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

B) data mining

Which of the following refers to data in the form of rows and columns? A) granulated data B) structured data C) nonintegrated data D) problematic 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

________ process operational and other data in organizations to analyze past performance and make predictions. A) Virtualization software 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) Push publishing C) Data mining D) Pull publishing

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

Which of the following statements is true of Hadoop? A) Hadoop is written in C++ and runs on Linux. B) Hadoop includes a query language entitled Big. C) Hadoop is an open-source program that implements MapReduce. D) Technical skills are not required to run and use Hadoop.

C) Hadoop is an open-source program that implements MapReduce.

The results generated in the Map phase are combined in the ________ phase. A) Pig B) control C) Reduce D) construct

C) Reduce

________ are business intelligence documents that are fixed at the time of creation and do not change. A) Subscriptions B) Third-party cookies C) Static reports D) Exception reports

C) Static reports

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

C) data warehouse

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 D) BigData

C) reporting

The use of an organization's operational data as the source data for a BI 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 external data and not internal data regarding an organization's functions

C) requires considerable processing and can drastically reduce system performance

Regression analysis is used in ________. A) static reporting B) exception 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 interpretation B) Pull publishing C) Push publishing D) Data acquisition

D) Data acquisition

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

D) Dynamic

In the ________ phase, a BigData collection is broken into pieces and hundreds or thousands of independent processors search these pieces for something of interest. A) crash B) control C) Pig D) Map

D) Map

________ 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) Pull publishing C) Cloud computing D) Reporting analysis

D) Reporting analysis

The purpose of a ________ is 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 referred to as ________. A) rough data B) clickstream data C) granular 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