Deck 9: Business Intelligence Systems

Question 1

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

Answer 1

B

Question 2

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

Answer 2

C

Question 3

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.

Answer 3

D

Question 4

________ 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

Question 5

________ is the process of sorting,grouping,summing,filtering,and formatting structured data.

A) Push publishing
B) Pull publishing
C) Cloud computing
D) Reporting analysis

Question 6

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

Question 7

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.

Question 8

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

Question 9

________ refers to the level of detail represented by data.

A) Abstraction
B) Granularity
C) Dimensionality
D) Aggregation

Question 10

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

Question 11

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

A) Data interpretation
B) Pull publishing
C) Push publishing
D) Data acquisition

Question 12

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.

Question 13

A ________ is a facility for managing an organization's business intelligence data.

A) datasheet
B) dataspace
C) data warehouse
D) data room

Question 14

________ requires users to request business intelligence results.

A) Push publishing
B) Pull publishing
C) Data acquisition
D) Data mining

Question 15

Problematic data are referred to as ________.

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

Question 16

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

Question 17

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

Question 18

________ 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

Question 19

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

Question 20

The source,format,assumptions,constraints,and other facts concerning certain data are called ________.

A) metadata
B) data structures
C) microdata
D) network packets

Question 21

________ reports are business intelligence documents that are updated at the time they are requested.

A) Subscriptions
B) Third-party cookies
C) Static
D) Dynamic

Question 22

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

Question 23

Regression analysis is used in ________.

A) static reporting
B) exception reporting
C) supervised data mining
D) unsupervised data mining

Question 24

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.

Question 25

________ 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

Question 26

________ 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

Question 27

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.

Question 28

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.

Question 29

________ 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

Question 30

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

Question 31

________ 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

Question 32

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.

Question 33

________ 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

Question 34

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

Question 35

The results generated in the Map phase are combined in the ________ phase.

A) Pig
B) control
C) Reduce
D) construct

Question 36

________ are reports produced when something out of predefined bounds occurs.

A) Exception reports
B) Static reports
C) Dynamic reports
D) Subscriptions

Question 37

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

Question 38

________ 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

Question 39

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

Question 40

________ 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

Question 41

Data marts are usually larger than data warehouses.

Question 42

Business intelligence enables police departments to better utilize their personnel through predictive-policing.

Question 43

The software component of a business intelligence system is called a business intelligence database.

Question 44

External data purchased from outside resources are not included in data warehouses.

Question 45

The curse of dimensionality states that the more attributes there are,the more difficult it is to build a model that fits the sample data.

Question 46

A data warehouse is a facility for managing an organization's business intelligence data.

Question 47

Facts about data,such as its source,format,assumptions,and constraints,are called metadata.

Question 48

Pull publishing delivers business intelligence to users without any request from the users.

Question 49

The data that an organization purchases from data vendors can act as the source data for a business intelligence system.

Question 50

Data marts are data collections that address the needs of a particular department or functional area of a business.

Question 51

Data granularity refers to the level of detail represented by data.

Question 52

Publish results is the process of delivering business intelligence to the knowledge workers who need it.

Question 53

Project management is one of the few domains in which business intelligence is rarely used.

Question 54

The granularity in clickstream data is too coarse.

Question 55

Problematic data are termed dirty data.

Question 56

Data analysts who work with data warehouses are not usually experts in a given business function.

Question 57

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

Question 58

If the granularity of certain data is too coarse,the data can be separated into constituent parts using statistical techniques.

Question 59

Business intelligence systems are information systems that process operational and other data to analyze past performance and to make predictions.

Question 60

Using BI for identifying changes in the purchasing patterns of customers is a labor-intensive process.

Question 61

Cluster analysis measures the impact of a set of variables on another variable.

Question 62

A printed sales analysis is an example of a dynamic report.

Question 63

The management function of BI servers maintains metadata about the authorized allocation of BI results to users.

Question 64

Push options are manual when emails or collaboration tools are used for BI publishing.

Question 65

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

Question 66

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

Question 67

An advantage of data warehouses is the low cost required to create,staff,and operate them.

Question 68

Reporting analysis is used primarily for classifying and predicting BI data.

Question 69

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

Question 70

BigData has volume,velocity,and variation characteristics that far exceed those of traditional reporting and data mining.

Question 71

How does business intelligence help marketers identify changes in the purchasing patterns of customers?

Question 72

BigData has low velocity and is generated slowly.

Question 73

What are business intelligence systems?

Question 74

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

Question 75

What are the three primary activities in the business intelligence process?

Question 76

Structured data is data in the form of rows and columns.

Question 77

Users in a data mart obtain data that pertain to a particular business function from a data warehouse.

Question 78

Static reports are business intelligence documents that are updated at the time they are requested.

Question 79

What is predictive-policing?

Question 80

For dynamic content,the skills required to create a publishing application are low.